News for hackers. Stuff that matters.

A comment on What's new in the Postgres 16 query planner (a.k.a. optimizer). Parent comment

Re:What's new in the Postgres 16 query planner (a.k.a. optim... by dur-randir on Friday February 09, 2024 @06:30AM (#39313769)
There's a separate can of worms with prepared statements. Two main are:

- parameters are opaque to planner, so it prefers (or is even forced to?) to choose generic vs specific plans

- it doesn't play nice with pg_bouncer in transaction mode

[ Parent | on HN ]
Re:What's new in the Postgres 16 query planner (a.k.a. optim... by jeltz on Friday February 09, 2024 @08:55AM (#39314852)
Pgbouncer supports prepared statements these days.
[ Parent | on HN ]