Scaling Postgres

Hosted by Creston Jamison

Technology

Website RSS feed

Episodes

430

Latest episode

Aug 2026

Language

About the show

Learn how to get the best performance and scale your PostgreSQL database with our weekly shows. Receive the best content curated from around the web. We have a special focus on content for developers since your architecture and usage is the key to getting the most performance out of PostgreSQL.

Listen to episodes

60 recent

August 23, 202611 min

pg_rust Co-Creator postgres.fm Interview | Scaling Postgres 431

In this episode of Scaling Postgres, we cover postgres.fm's interview of pgrust co-creator Michael Malis, pgDog vs RDS Proxy, Postgres on Kubernetes in 10 minutes and evolution to Postgres 19. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/431-pgrust-co-creator-postgresfm-interview/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

August 16, 202610 min

28 Security Vulnerabilities | Scaling Postgres 430

In this episode of Scaling Postgres, we discuss new releases fixing 28 security vulnerabilities, more MVCC, BYOK encryption and should Postgres include pgbouncer. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/430-28-security-vulnerabilities/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

August 9, 202613 min

300 Times Faster Analytics With pgrust | Scaling Postgres 429

In this episode of Scaling Postgres, we discuss pgrust running analytical queries 300 times faster than Postgres, how to speed up distinct count, Xata podcast and massively parallel backups. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/429-300-times-faster-analytics-with-pgrust/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

August 2, 202617 min

Postgres MVCC Is Bad? | Scaling Postgres 428

In this episode of Scaling Postgres, we discuss how bad Postgres MVCC is, a startup's survival guide for Postgres, an examination of DBOS, and different ways of performing hybrid searches. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/428-postgres-mvcc-is-bad/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

July 26, 20268 min

Migrating to pg_hardstorage | Scaling Postgres 427

In this episode of Scaling Postgres, we discuss migrating to pg_hardstorage for Postgres backup, PG 19 Beta 2 is released, collecting log stats with pg_stat_log and PG 19 checkpoint additions. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/427-migrating-to-pg_hardstorage/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

July 19, 202615 min

pgrust Faster Than Postgres? | Scaling Postgres 426

In this episode of Scaling Postgres, we discuss the progress of the Rust rewrite of Postgres called pgrust, more about the backup tool pg_hardstorage, beware listen / notify and how to fix bad SQL. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/426-pgrust-faster-than-postgres/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

July 12, 202617 min

Novel Partition Exclusion | Scaling Postgres 425

In this episode of Scaling Postgres, we discuss excluding partitions without using a partition key, a pgBackRest interview, Postgres backup without an incremental chain and a replication deadlock bug in Postgres 14-16. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/425-novel-partition-exclusion/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

July 5, 202615 min

Too Many Table Danger | Scaling Postgres 424

In this episode of Scaling Postgres, we discuss the dangers of too many tables, don't worry about extending checkpoint_timeout, a disaster recovery process, and non-repeatable sums with floating point numbers. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/424-too-many-table-danger/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

June 28, 202614 min

New Backup Tool | Scaling Postgres 423

In this episode of Scaling Postgres, we discuss a new backup tool called pg_hardstorage by Cybertech, bottomless storage & ColdFront, monitoring checkpoints and tracking statistics. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/423-new-backup-tool/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/

June 21, 202613 min

Scaling Out To 226K TPS | Scaling Postgres 422

In this episode of Scaling Postgres, we discuss scaling out application writes to achieve 226K TPS, try to avoid delete, disaster recovery is a process and avoid NULL in your NOT IN. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/422-scaling-out-to-226k-tps/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/