Migrating to pg_hardstorage | Scaling Postgres 427

Migrating to pg_hardstorage | Scaling Postgres 427

Author: Creston Jamison July 27, 2026 Duration: 8:29
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/

If you're working with PostgreSQL, you know that growth brings a unique set of challenges. Scaling Postgres, hosted by Creston Jamison, is a weekly resource dedicated to navigating those exact hurdles. This isn't about abstract theory; it's a practical guide focused on extracting the best performance and building a resilient architecture as your data and user demands increase. Each episode serves as curated insight, distilling valuable information from across the web into actionable advice tailored for developers and engineers. The discussion consistently centers on how your specific application design and usage patterns are the fundamental levers for optimization. You'll hear clear explanations on configuration tuning, indexing strategies, replication, and managing bottlenecks-all through the lens of real-world scalability. Tune in to this technology podcast for a focused, developer-centric conversation that helps you build with confidence, ensuring your database infrastructure is robust, efficient, and ready for what's next.
Author: Language: English Episodes: 50

Scaling Postgres
Podcast Episodes
Postgres 19 Reversions | Scaling Postgres 434 [not-audio_url] [/not-audio_url]

Duration: 11:46
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 logi…
Read After Write | Scaling Postgres 433 [not-audio_url] [/not-audio_url]

Duration: 16:58
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 n…
23 Times Faster Inserts With UUIDv7 | Scaling Postgres 432 [not-audio_url] [/not-audio_url]

Duration: 15:36
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 g…
pg_rust Co-Creator postgres.fm Interview | Scaling Postgres 431 [not-audio_url] [/not-audio_url]

Duration: 11:06
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 we…
28 Security Vulnerabilities | Scaling Postgres 430 [not-audio_url] [/not-audio_url]

Duration: 10:15
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 epis…
300 Times Faster Analytics With pgrust | Scaling Postgres 429 [not-audio_url] [/not-audio_url]

Duration: 13:12
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…
Postgres MVCC Is Bad? | Scaling Postgres 428 [not-audio_url] [/not-audio_url]

Duration: 17:29
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 a…
pgrust Faster Than Postgres? | Scaling Postgres 426 [not-audio_url] [/not-audio_url]

Duration: 15:49
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…
Novel Partition Exclusion | Scaling Postgres 425 [not-audio_url] [/not-audio_url]

Duration: 17:16
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. T…
Too Many Table Danger | Scaling Postgres 424 [not-audio_url] [/not-audio_url]

Duration: 15:22
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…