Skip to content
PodSubs
ShowsPeopleGuestsJobsNewsEvents
More
BlogPodCred
Menu
ShowsPeopleGuestsJobsNewsEventsBlogPodCredNetworksSign in
Join nowSign in
  • Shows
  • People
  • Jobs
  • News
  • More
    • Guests
    • Events
    • Blog
    • PodCred
    • Networks
    Join nowSign in
Scaling Postgres artwork

Podcast

Scaling Postgres

Creston Jamison

Technology · 443 episodes
  • Website
Follow

Guests who follow get this show's guest call alerts.

Subscribe+ Add a credit

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 on
  • Apple Podcasts
  • Find on Spotify
EpisodesPeoplePostsSubscribe

Is this your show? Claim this page

Information

Creator
Creston Jamison
Category
Technology
Years active
2018 to 2026
Episodes
443
Show website
scalingpostgres.com

Sign in to suggest a network

PodCred

The people behind this show

People get invited back because someone remembered they were great.

PodCred is the verified record of who made this show. A credit here means people who were there confirmed the work.

Hosts

  • C
    Creston JamisonHostFeed-stated

Who is on this show?

Think of the guest you still think about. The producer who makes the host sound smart. The editor who saves every episode. If a name is missing here, that person is invisible everywhere.

Add a credit

Episodes

443 episodes
443 episodes
  1. Postgres Releases & 52 Security Fixes | Scaling Postgres 443

    Nov 15, 202617 minAudio

    In this episode of Scaling Postgres, we discuss new Postgres minor releases that patch 52(!) vulnerabilities, the AI impact on Postgres, pgrust progress, and handling extensions in containers. To get the show notes as...

    Credit the people on this episode

  2. Bare Metal Speed Postgres? | Scaling Postgres 442

    Nov 8, 202617 minAudio

    In this episode of Scaling Postgres, we discuss the public beta of Oriole DB, 100,000 times faster queries with GPUs, post pg_restore to-do and a lesson in data integrity. To get the show notes as well as get notified...

    Credit the people on this episode

  3. 100K Faster Queries With GPUs! | Scaling Postgres 441

    Nov 1, 202620 minAudio

    In this episode of Scaling Postgres, we discuss the public beta of Oriole DB, 100,000 times faster queries with GPUs, post pg_restore to-do and a lesson in data integrity. To get the show notes as well as get notified...

    Credit the people on this episode

  4. 10 Million QPS . . . Efficiently | Scaling Postgres 440

    Oct 25, 202616 minAudio

    In this episode of Scaling Postgres, we discuss how to reach 10 million queries per second efficiently, Postgres performance on GPUs, the next release of pgrust and not trusting ON DELETE CASCADE. To get the show notes...

    Credit the people on this episode

  5. Text Search Battle Royale! | Scaling Postgres 439

    Oct 18, 202616 minAudio

    In this episode of Scaling Postgres, we review two companies battling one another for text search dominance in Postgres, faster vector search with pg_vectorsearch, pushing Citus scaling with query routers and PostgreSQL...

    Credit the people on this episode

  6. Competition Is Good | Scaling Postgres 438

    Oct 11, 202611 minAudio

    In this episode of Scaling Postgres, we discuss performance improvements in ParadeDB as a result of PlanetScale, an open source BM25 index from PGX Inc., pgbouncer and pgvector patching and direct I/O benefits during...

    Credit the people on this episode

  7. The Reason For Reversions | Scaling Postgres 437

    Oct 4, 202617 minAudio

    In this episode of Scaling Postgres, we discuss the reasons for all the PG 19 reversions, why open source wins, the cost of REPACK CONCURRENTLY and hint implementations. To get the show notes as well as get notified of...

    Credit the people on this episode

  8. Postgres 19 Beta 4 Released! | Scaling Postgres 436

    Sep 27, 202612 minAudio

    In this episode of Scaling Postgres, we discuss PG19 Beta 4, pgBouncer CVEs, managed provider security and transferring data to Clickhouse using physical replication. To get the show notes as well as get notified of new...

    Credit the people on this episode

  9. Postgres 19 Revert Train! | Scaling Postgres 435

    Sep 20, 202611 minAudio

    In this episode of Scaling Postgres, we discuss possibly twelve different feature reversions in Postgres 19 and why, the impact of one more index, the cost of a single insert and Neki is released. To get the show notes...

    Credit the people on this episode

  10. Postgres 19 Reversions | Scaling Postgres 434

    Sep 13, 202612 minAudio

    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...

    Credit the people on this episode

  11. Read After Write | Scaling Postgres 433

    Sep 6, 202617 minAudio

    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...

    Credit the people on this episode

  12. 23 Times Faster Inserts With UUIDv7 | Scaling Postgres 432

    Aug 30, 202616 minAudio

    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...

    Credit the people on this episode

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

    Aug 23, 202611 minAudio

    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...

    Credit the people on this episode

  14. 28 Security Vulnerabilities | Scaling Postgres 430

    Aug 16, 202610 minAudio

    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...

    Credit the people on this episode

  15. 300 Times Faster Analytics With pgrust | Scaling Postgres 429

    Aug 9, 202613 minAudio

    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...

    Credit the people on this episode

  16. Postgres MVCC Is Bad? | Scaling Postgres 428

    Aug 2, 202617 minAudio

    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...

    Credit the people on this episode

  17. Migrating to pg_hardstorage | Scaling Postgres 427

    Jul 26, 20268 minAudio

    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...

    Credit the people on this episode

  18. pgrust Faster Than Postgres? | Scaling Postgres 426

    Jul 19, 202616 minAudio

    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...

    Credit the people on this episode

  19. Novel Partition Exclusion | Scaling Postgres 425

    Jul 12, 202617 minAudio

    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....

    Credit the people on this episode

  20. Too Many Table Danger | Scaling Postgres 424

    Jul 5, 202615 minAudio

    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...

    Credit the people on this episode

  21. New Backup Tool | Scaling Postgres 423

    Jun 28, 202615 minAudio

    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...

    Credit the people on this episode

  22. Scaling Out To 226K TPS | Scaling Postgres 422

    Jun 21, 202613 minAudio

    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...

    Credit the people on this episode

  23. Scale Out Funding | Scaling Postgres 421

    Jun 14, 202610 minAudio

    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...

    Credit the people on this episode

  24. Postgres 19 Beta 1 Released | Scaling Postgres 420

    Jun 7, 202619 minAudio

    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...

    Credit the people on this episode

  25. The Dynamic Duo? | Scaling Postgres 419

    May 31, 202616 minAudio

    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...

    Credit the people on this episode

  26. Multigres Architecture | Scaling Postgres 418

    May 24, 202617 minAudio

    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...

    Credit the people on this episode

  27. 11 Security Issues | Scaling Postgres 417

    May 17, 202620 minAudio

    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...

    Credit the people on this episode

  28. Zero Bloat Postgres Queue | Scaling Postgres 416

    May 10, 202615 minAudio

    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...

    Credit the people on this episode

  29. pgBackRest Is Dead? | Scaling Postgres 415

    May 3, 202616 minAudio

    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...

    Credit the people on this episode

  30. Repack Concurrently | Scaling Postgres 414

    Apr 26, 202620 minAudio

    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...

    Credit the people on this episode

  31. Shard With One Command | Scaling Postgres 413

    Apr 19, 202620 minAudio

    In this episode of Scaling Postgres, we discuss sharding your database with one command, more information about the Linux 7 Postgres performance regression, Xata going open source, and checkpoints and WAL storms. To get...

    Credit the people on this episode

  32. Half as Fast on Linux 7 | Scaling Postgres 412

    Apr 12, 202616 minAudio

    In this episode of Scaling Postgres, we discuss how Postgres may be half as fast on the new Linux 7 kernel, PostgresBench, what is missing in Postgres and WAL to distribute data. To get the show notes as well as get...

    Credit the people on this episode

  33. Absorbing Load | Scaling Postgres 411

    Apr 5, 202620 minAudio

    In this episode of Scaling Postgres, we discuss techniques to absorb excessive query load, BM25 text search via pg_textsearch, good & bad CTEs and plan_cache_mode. To get the show notes as well as get notified of new...

    Credit the people on this episode

  34. Postgres Traffic Cop! | Scaling Postgres 410

    Mar 29, 202612 minAudio

    In this episode of Scaling Postgres, we discuss a proprietary way of controlling Postgres query traffic, preserving statistics during upgrades, a DB schema migration survey and a new repack command. To get the show...

    Credit the people on this episode

  35. Iceberg Causes Postgres Acquisitions? | Scaling Postgres 409

    Mar 22, 202614 minAudio

    In this episode of Scaling Postgres, we discuss how Apache Iceberg may have lead to Postgres company acquisitions, presentations on CloudNativePG & query tuning, setting up Patroni and utilizing PgBouncer. To get the...

    Credit the people on this episode

Show moreShowing 35 of 443

Posts

No posts yet. Posts Scaling Postgres shares on PodSubs, and what it publishes on Substack, YouTube and its own site, will show here.

Be the first to rate this show

Subscribe

Be on the front line of the show

Everything Scaling Postgres sends its own people, first. Resources, announcements, behind the scenes, events, and giveaways, straight from the host. No account needed.

  • The resources the host shares with subscribers
  • Announcements before anyone else hears
  • Behind the scenes from the team
  • Events, invitations, and giveaways
  • Only what the host sends, nothing else
How often

Audio and video play straight from the show's own hosting. PodSubs stores and serves no media.

Report this show

Similar shows

  • Kim Komando Daily Tech Update artwork

    Kim Komando Daily Tech Update

    Also in Technology

    4,864 episodes

    Updated Nov 21, 2026

  • Rebuild artwork

    Rebuild

    Also in Technology

    561 episodes

    Updated Nov 21, 2026

  • Dad Reviews with @LaneVids (Svenska) artwork

    Dad Reviews with @LaneVids (Svenska)

    Also in Technology

    115 episodes

    Updated Nov 21, 2026

  • Tech Café : tech & IA artwork

    Tech Café : tech & IA

    Also in Technology

    561 episodes

    Updated Nov 21, 2026

  • Dad Reviews with @LaneVids (Deutsch) artwork

    Dad Reviews with @LaneVids (Deutsch)

    Also in Technology

    279 episodes

    Updated Nov 21, 2026

  • Dad Reviews with @LaneVids (Português) artwork

    Dad Reviews with @LaneVids (Português)

    Also in Technology

    278 episodes

    Updated Nov 21, 2026

  • Dad Reviews with @LaneVids (日本語) artwork

    Dad Reviews with @LaneVids (日本語)

    Also in Technology

    278 episodes

    Updated Nov 21, 2026

  • Dad Reviews with @LaneVids (Français) artwork

    Dad Reviews with @LaneVids (Français)

    Also in Technology

    279 episodes

    Updated Nov 21, 2026