77 Times Faster In Postgres 17 | Scaling Postgres 337

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

In this episode of Scaling Postgres, we discuss how one query runs 77 times faster in Postgres 17, a detailed Postgres 17 performance webinar, using logical replication fail over slots and a discussion on Patroni.

Want to learn more about Postgres performance?

Timestamps:
00:00 - Intro
00:26 - As Rails developers, why we are excited about PostgreSQL 17
03:04 - [YouTube] Webinar Recording: Hands on Postgres 17: What's New & How It Impacts Performance
04:13 - Failover Slots in PostgreSQL-17: Ensuring High Availability with Logical Replication
07:56 - Patroni
09:07 - Waiting for PostgreSQL 18 – Add temporal FOREIGN KEY contraints
09:46 - Announcing ParadeDB partnership: Search and Analytics for Postgres
10:44 - PostgreSQL adds the login type for event triggers
11:09 - PostgreSQL 17 allow_alter_system tunable
11:49 - AI-assisted Postgres experiment: number of partitions vs. planning time
13:10 - Optimizing Postgres table layout for maximum efficiency
13:53 - Outro

#postgres #postgresql