Read After Write | Scaling Postgres 433

Read After Write | Scaling Postgres 433

Author: Creston Jamison September 7, 2026 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 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/

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
New Backup Tool | Scaling Postgres 423 [not-audio_url] [/not-audio_url]

Duration: 14:55
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 n…
Scaling Out To 226K TPS | Scaling Postgres 422 [not-audio_url] [/not-audio_url]

Duration: 13:26
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…
Scale Out Funding | Scaling Postgres 421 [not-audio_url] [/not-audio_url]

Duration: 9:41
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 no…
Postgres 19 Beta 1 Released | Scaling Postgres 420 [not-audio_url] [/not-audio_url]

Duration: 18:57
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…
The Dynamic Duo? | Scaling Postgres 419 [not-audio_url] [/not-audio_url]

Duration: 15:39
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…
Multigres Architecture | Scaling Postgres 418 [not-audio_url] [/not-audio_url]

Duration: 16:51
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…
11 Security Issues  | Scaling Postgres 417 [not-audio_url] [/not-audio_url]

Duration: 19:56
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 sho…
Zero Bloat Postgres Queue  | Scaling Postgres 416 [not-audio_url] [/not-audio_url]

Duration: 15:09
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 no…
pgBackRest Is Dead?  | Scaling Postgres 415 [not-audio_url] [/not-audio_url]

Duration: 16:26
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 no…
Repack Concurrently  | Scaling Postgres 414 [not-audio_url] [/not-audio_url]

Duration: 19:55
In this episode of Scaling Postgres, we discuss repack concurrently coming to PG 19, how to design your schema, all about hints and enforcing constraints across partitions. To get the show notes as well as get notified o…