Scaling Postgres

In this episode of Scaling Postgres, we discuss how open source is eating the world, mitigating plan flips, migrating from Heroku to RDS, and how work_mem is a trap.

To get the show notes as well as get notified of new episodes, visit: 
https://www.scalingpostgres.com/episodes/408-open-source-eating-the-world/

Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

In this episode of Scaling Postgres, we discuss the possibility of having stable plans in Postgres 19, settings to kill disconnected or crashed clients, on conflict do select and all about Patroni.

To get the show notes as well as get notified of new episodes, visit: 
https://www.scalingpostgres.com/episodes/407-stable-plans/

Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

In this episode of Scaling Postgres, we discuss how a lock can cause data to vanish, new Postgres releases, fast replication with peerDB and pg_ash for wait sampling.

To get the show notes as well as get notified of new episodes, visit: 
https://www.scalingpostgres.com/episodes/406-lock-causes-data-to-vanish/

Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

In this episode of Scaling Postgres, we discuss an out of cycle Postgres release, a Supabase downtime incident, optimizing top K queries and how to maintain reading efficiency.

To get the show notes as well as get notified of new episodes, visit: 
https://www.scalingpostgres.com/episodes/405-out-of-cycle-releases/

Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

In this episode of Scaling Postgres, we discuss how the postmaster does not scale, new Postgres releases, data storage using PAX and a path generation strategies change.

To get the show notes as well as get notified of new episodes, visit: 
https://www.scalingpostgres.com/episodes/404-postmaster-does-not-scale/

Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/