PgBouncer, PgCat, Supavisor Fight!!! | Scaling Postgres 303

To get the show notes as well as get notified of new episodes, visit:

In this episode of Scaling Postgres, we discuss new Postgres releases, performance comparisons between PgBouncer, PgCat and Supavisor, a new extension pg_analytics, and new planner capabilities in PG16.

Want to learn more about Postgres performance?

Timestamps:
00:00 - Postgres Performance Demystified Webinar
00:42 - PostgreSQL 16.2, 15.6, 14.11, 13.14, and 12.18 Released!
02:15 - Benchmarking PostgreSQL connection poolers: PgBouncer, PgCat and Supavisor
08:46 - pg_analytics: Transforming Postgres into a Fast OLAP Database
11:10 - What’s new in the Postgres 16 query planner / optimizer
12:35 - Faster query plans with Postgres 16: Incremental Sorts, Anti-JOINs and more
12:54 - Recommended resources to improve your knowledge of Databases and PostgreSQL
14:11 - Waiting for PostgreSQL 17 – Support identity columns in partitioned tables
14:43 - Waiting for PostgreSQL 17 – Add new COPY option SAVE_ERROR_TO / Rename COPY option from SAVE_ERROR_TO to ON_ERROR
16:37 - Postgres Not Starting: The Case of the Missing Output
18:05 - Postgres 16 contribution analysis 2023
19:28 - Outro

#postgres #postgresql

[RU-qvjl]

Appreciate the content and sharing your opinions, thanks.

[ianokay]

Do you have any videos you can direct to that speak about what the overhead actually is for establishing connections without pooling and how that acts at scale? Is this that video in a sense? Do you have any others? I've always been curious about what that overhead really is and what takes the most overhead in the connection process.

[rosendo]

there is also postgresql 15 internals by egor rogov, but has not been translated to english yet

[rosendo]

how can we see all the job openings of AWS team related to postgresql developement? amazon career page is so complicated.

[AmitVarde]

pgBouncer can be configured to use multiple CPUs. But it's a little involved and not out of the box.
Still it's shocking that this benchmark did not consider that.