Scaling Postgres

Епизоде

• 
  Postgres 19 Reversions | Scaling Postgres 434 13.09.2026 11мин

  In this episode of Scaling Postgres, we discuss various reversions and the uncertain release date of Postgres 19, pgSafe a new backup solution written in Go, inserting state transitions and an operator that supports logical replicas. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/434-postgres-19-reversions/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/
• 
  Read After Write | Scaling Postgres 433 06.09.2026 16мин

  In this episode of Scaling Postgres, we see examples of using WAIT FOR in PG 19 for handling read after write, local NVME vs block store, new system views and the ambiguity of NULL. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/433-read-after-write/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/
• 
  23 Times Faster Inserts With UUIDv7 | Scaling Postgres 432 30.08.2026 15мин

  In this episode of Scaling Postgres, we discuss getting 23 times faster inserts with UUIDv7, the benefits and downsides of UUIDs, how to optimize queries without table changes and using WAIT FOR to read your writes. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/432-23-times-faster-inserts-with-uuidv7/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/
• 
  pg_rust Co-Creator postgres.fm Interview | Scaling Postgres 431 23.08.2026 11мин

  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/
• 
  28 Security Vulnerabilities | Scaling Postgres 430 16.08.2026 10мин

  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/
• 
  300 Times Faster Analytics With pgrust | Scaling Postgres 429 09.08.2026 13мин

  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/
• 
  Postgres MVCC Is Bad? | Scaling Postgres 428 02.08.2026 17мин

  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/
• 
  Migrating to pg_hardstorage | Scaling Postgres 427 26.07.2026 8мин

  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/
• 
  pgrust Faster Than Postgres? | Scaling Postgres 426 19.07.2026 15мин

  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/
• 
  Novel Partition Exclusion | Scaling Postgres 425 12.07.2026 17мин

  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/
• 
  Too Many Table Danger | Scaling Postgres 424 05.07.2026 15мин

  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/
• 
  New Backup Tool | Scaling Postgres 423 28.06.2026 14мин

  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/
• 
  Scaling Out To 226K TPS | Scaling Postgres 422 21.06.2026 13мин

  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/
• 
  Scale Out Funding | Scaling Postgres 421 14.06.2026 9мин

  In this episode of Scaling Postgres, we discuss scale out Postgres projects getting more funding, getting started with Postgres 19 Beta 1 along with its top features and how to review a Postgres patch. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/421-scale-out-funding/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/
• 
  Postgres 19 Beta 1 Released | Scaling Postgres 420 07.06.2026 18мин

  In this episode of Scaling Postgres, we discuss the release of Postgres 19 Beta 1, optimizing autovacuum, the release of Multigres 0.1 Alpha 1, and handling graph queries in Postgres. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/420-postgres-19-beta-1-released/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/
• 
  The Dynamic Duo? | Scaling Postgres 419 31.05.2026 15мин

  In this episode of Scaling Postgres, we go over the architecture of Multigres (Vitess for Postgres), pgBackRest's status, pg_flight_recorder and general SQL optimizations. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/419-dynamic-duo/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/
• 
  Multigres Architecture | Scaling Postgres 418 24.05.2026 16мин

  In this episode of Scaling Postgres, we go over the architecture of Multigres (Vitess for Postgres), pgBackRest's status, pg_flight_recorder and general SQL optimizations. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/418-multigres-architecture/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/
• 
  11 Security Issues | Scaling Postgres 417 17.05.2026 19мин

  In this episode of Scaling Postgres, we discuss new Postgres releases that patch eleven security issues, a new pgbouncer release patching four security issues, making JSON queryable, and issues with views. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/417-eleven-security-issues/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/
• 
  Zero Bloat Postgres Queue | Scaling Postgres 416 10.05.2026 15мин

  In this episode of Scaling Postgres, we discuss a new zero bloat Postgres queue called PgQue, maybe pgBackRest isn't dead, multixact members at 64 bits and using session variables. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/416-zero-bloat-postgres-queue/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/
• 
  pgBackRest Is Dead? | Scaling Postgres 415 03.05.2026 16мин

  In this episode of Scaling Postgres, we discuss the notice of obsolescence for pgBackRest, the open source environment in general, queries to monitor autovacuum and pg_wait_tracer. To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episodes/415-pgbackrest-is-dead/ Want to learn more about Postgres performance? Join my FREE training called Postgres Performance Demystified here: https://www.scalingpostgres.com/courses/postgres-performance-demystified/