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 in the Podli app 🎧
Follow your favourite podcasts, listen offline and in the car with CarPlay and Android Auto, and always pick up where you left off. Free to try.
Sep 27, 2026 · 12:00
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…
Sep 20, 2026 · 10:34
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…
Sep 13, 2026 · 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…
Sep 6, 2026 · 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…
Aug 30, 2026 · 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…
Aug 23, 2026 · 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…
Aug 16, 2026 · 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…
Aug 9, 2026 · 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…
Aug 2, 2026 · 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…
Jul 26, 2026 · 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…
Jul 19, 2026 · 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…
Jul 12, 2026 · 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…
Jul 5, 2026 · 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…
Jun 28, 2026 · 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…
Jun 21, 2026 · 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…
Jun 14, 2026 · 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…
Jun 7, 2026 · 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…
May 31, 2026 · 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…
May 24, 2026 · 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…
May 17, 2026 · 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…
May 10, 2026 · 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…
May 3, 2026 · 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…
Apr 26, 2026 · 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…
Apr 19, 2026 · 19:52
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…
Apr 12, 2026 · 15:31
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.…
Apr 5, 2026 · 19:55
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…
Mar 29, 2026 · 12:12
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…
Mar 22, 2026 · 14:07
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…
Mar 15, 2026 · 17:05
In this episode of Scaling Postgres, we discuss how open source is eating the world, mitigating plan flips, migrating from Heroku to RDS, and how work_mem is a trap. To get the…
Mar 8, 2026 · 18:48
In this episode of Scaling Postgres, we discuss the possibility of having stable plans in Postgres 19, settings to kill disconnected or crashed clients, on conflict do select and…
Mar 1, 2026 · 18:21
In this episode of Scaling Postgres, we discuss how a lock can cause data to vanish, new Postgres releases, fast replication with peerDB and pg_ash for wait sampling. To get the…
Feb 22, 2026 · 16:59
In this episode of Scaling Postgres, we discuss an out of cycle Postgres release, a Supabase downtime incident, optimizing top K queries and how to maintain reading efficiency.…
Feb 15, 2026 · 17:21
In this episode of Scaling Postgres, we discuss how the postmaster does not scale, new Postgres releases, data storage using PAX and a path generation strategies change. To get…
Feb 8, 2026 · 16:22
In this episode of Scaling Postgres, we discuss a potential way to mitigate retry storms or orphan DB sessions with client_connection_check_interval, checkpoint configuration,…
Feb 1, 2026 · 18:25
In this episode of Scaling Postgres, we discuss how OpenAI's ChatGPT handles millions of queries per second, an update on PgDog, Clickhouse offers OLTP hosted Postgres and…
Jan 25, 2026 · 22:06
In this episode of Scaling Postgres, we discuss searching one billion vectors on Postgres, how to bypass a vector index search, unconventional optimizations and a 40x boost to…
Jan 18, 2026 · 17:42
In this episode of Scaling Postgres, we discuss the cost of arrays, dealing with integer overflow, idle sessions causing transaction wraparound and AI or LLM index…
Jan 11, 2026 · 19:18
In this episode of Scaling Postgres, we discuss the overhead of indexes, a Postgres year in review, an intro to row locking and table renaming issues. To get the show notes as…
Jan 4, 2026 · 19:42
In this episode of Scaling Postgres, we examine how latency impacts performance, naughty queries, bm25 indexes and how to quickly create database clones. To get the show notes as…
Dec 21, 2025 · 16:48
In this episode of Scaling Postgres, we discuss if vacuum is lying to you with regard to index cleanup, an agentic toolkit with MCP server, indexes getting corrupted after an…
Dec 14, 2025 · 18:48
In this episode of Scaling Postgres, we discuss using Postgres queries in ClickHouse, faster faceted search, max_connections & migrations and different scan types. To get the…
Dec 7, 2025 · 16:11
In this episode of Scaling Postgres, we discuss a patch that can plan joins 16 times faster, the best way to record text values, extensions via image volumes with CloudNativePG…
Nov 30, 2025 · 16:28
In this episode of Scaling Postgres, we discuss my Black Friday / Cyber Monday course deal, the job security that LLMs provide, new Postgres releases and why you should hard your…
Nov 23, 2025 · 14:41
In this episode of Scaling Postgres, we discuss my Black Friday / Cyber Monday course deal, the job security that LLMs provide, new Postgres releases and why you should shard…
Nov 16, 2025 · 15:52
In this episode of Scaling Postgres, we discuss performance improvements related to skip scans, faster backup & restore, benefits of minimal indexes and more details about my…
Nov 9, 2025 · 19:15
In this episode of Scaling Postgres, we discuss the issues of partition locking during planning, the problem of too much memory, the importance of a txvector column and an…
Nov 2, 2025 · 17:32
In this episode of Scaling Postgres, we discuss how far Postgres can scale with queue and pub/sub workloads, temporal joins, IPC:SyncRep and nested partitioning. To get the show…
Oct 26, 2025 · 14:21
In this episode of Scaling Postgres, we discuss ways to optimize reading or writing, the benefits of a descending index, more information about lightweight locks and a backup…
Oct 19, 2025 · 16:26
In this episode of Scaling Postgres, we discuss PG17 and PG18 benchmarks across storage types, more about Postgres locks, sanitizing SQL and can a faster software & hardware…
Oct 12, 2025 · 15:54
In this episode of Scaling Postgres, we explore how PG18 locking changes can boost planning performance, how to store data safely on a budget, how to build a parquet file archive…
Oct 5, 2025 · 15:03
In this episode of Scaling Postgres, we discuss additional Postgres 18 features, some future features for Postgres, how to use update with limit and how recent Ubuntu OS patches…
Sep 28, 2025 · 17:07
In this episode of Scaling Postgres, we discuss the release of Postgres 18 and cover different features such as asynchronous I/O, enhanced return from statements, parallel apply,…
Sep 21, 2025 · 17:25
In this episode of Scaling Postgres, we discuss getting excited about Postgres 18, oauth authentication, reconsidering your interface and a zero downtime upgrade. To get the show…
Sep 14, 2025 · 13:20
In this episode of Scaling Postgres, we discuss free availability of an OrioleDB patent, pgEdge going open source, pg_duckdb hitting 1.0 and methods resolve to slow order by…
Sep 7, 2025 · 19:03
In this episode of Scaling Postgres, we discuss using a LLM as an agent, the importance of partitioned table statistics, PG 18 RC1, primary keys in sharded databases and a…
Aug 31, 2025 · 9:44
In this episode of Scaling Postgres, we discuss DocumentDB moving to the Linux Foundation, multi-column indexes, SCRAM pass-through and RDS Proxy oddities. To get the show notes…
Aug 24, 2025 · 14:53
In this episode of Scaling Postgres, we discuss enhancements to Oriole DB, new Postgres releases, a logging guide and application framework frustrations. To get the show notes as…
Aug 17, 2025 · 19:03
In this episode of Scaling Postgres, we discuss when you should reindex, how to handle case insensitive data, how to index jsonb and the top recommendations when doing…
Aug 10, 2025 · 19:29
In this episode of Scaling Postgres, we discuss Postgres getting a native column store via an index, faster btree_gift indexes, scaling listen/notify, and a logical replication…
Aug 3, 2025 · 15:14
In this episode of Scaling Postgres, we discuss how to shard your DB at network speeds, how to make your DB 42,000 slower, new monitoring and just enough text searching…
Jul 27, 2025 · 19:45
In this episode of Scaling Postgres, we discuss a 100K events per second queue built on Postgres, how an MCP can leak your database, MultiXact ID and space overrun and struggles…
Jul 20, 2025 · 16:19
In this episode of Scaling Postgres, we discuss new benchmarks as a result of the Planetscale Postgres announcement, various platform improvements and a deep dive into Multigres.…
Jul 13, 2025 · 18:34
In this episode of Scaling Postgres, we discuss how Jira migrated millions of databases, when sigterm does nothing, should you ditch vector search and mastering replication…
Jul 6, 2025 · 14:22
In this episode of Scaling Postgres, we discuss the release of Planetscale Postgres and the advantages for bare metal, how often queries are optimal, avoiding UUIDv4 and the…
Jun 29, 2025 · 19:26
In this episode of Scaling Postgres, we discuss some possible futures for Postgres architectures, choosing a multi-tenancy model, vectors in the new SQL standard and one way to…
Jun 22, 2025 · 21:08
In this episode of Scaling Postgres, we discuss how you use the database can impact its performance, performance of pg_search, fast uploads and some downsides of different…
Jun 15, 2025 · 14:51
In this episode of Scaling Postgres, we discuss the start of Multigres which is a Vitess for Postgres, pgactive going open source, getting started with logical replication and a…
Jun 8, 2025 · 18:01
In this episode of Scaling Postgres, we discuss why and how you could move off of AWS RDS, Snowflake acquires Crunchy Data, reducing your SQL queries and a novel way to migrate…
Jun 1, 2025 · 19:10
In this episode of Scaling Postgres, we discuss the benefits of using time-based UUIDv7 vs UUIDv4 for primary keys, how OpenAI uses Postgres, handling locks and methods to…
May 25, 2025 · 13:10
In this episode of Scaling Postgres, we discuss a Postgres VS code extension, service definition files, undead tuples and the benefits of finding out how often a query is run. To…
May 18, 2025 · 14:46
In this episode of Scaling Postgres, we discuss a top ten dangerous Postgres issues list, importing and exporting statistics, more Postgres 18 beta features and a 20,000 times…
May 11, 2025 · 20:01
In this episode of Scaling Postgres, we discuss async I/O introduced in PG 18 Beta 1, new Postgres releases, PgDog performance and innovative ways to optimize queries. To get the…
May 4, 2025 · 20:39
In this episode of Scaling Postgres, we discuss scaling for high volume, why workflows should be Postgres rows, a planner gotcha and ways to resolve planner issues. To get the…
Apr 27, 2025 · 13:32
In this episode of Scaling Postgres, we discuss a top ten dos and don't for Postgres, understanding statistics and extended statistics, aligning columns to reduce padding and how…
Apr 20, 2025 · 12:22
In this episode, we discuss optimizing for time-series data, indexing vectors, Postgres APT extension packaging and how to optimize queries involving low cardinality data…
Apr 13, 2025 · 17:28
In this episode of Scaling Postgres, we discuss a roadmap to scaling Postgres, life altering Postgres patterns, making Postgres better with OrioleDB, performance cliffs and…
Apr 6, 2025 · 16:17
In this episode of Scaling Postgres, we discuss how a new tool pgDog might allow one million client connections to Postgres, novel use cases for pgvector other than semantic…
Mar 30, 2025 · 18:27
In this episode of Scaling Postgres, we talk about indexes being added to Timescale's column store, processing 1 trillion metrics in Timescale, processing 1 trillion rows in…
Mar 23, 2025 · 23:37
In this episode of Scaling Postgres, I discuss my experience attending Postgres Conference 2025 and cover some of the highlights of the conference. Interestingly, at least from…
Mar 16, 2025 · 9:58
In this episode of Scaling Postgres, we discuss best practices, caching monitoring statistics, a new vector extension called VectorChord and the importance of monitoring wait…
Mar 9, 2025 · 15:21
In this episode of Scaling Postgres, we discuss immutability and Postgres, the upcoming Postgres Conference in Orlando, extended statistics and usage of default partitions. To…
Mar 2, 2025 · 15:59
In this episode of Scaling Postgres, we discuss how Postgres & pg_mooncake achieves top ten Clickbench results, a comparison of Oracle and Postgres transactions, sharding to…
Feb 23, 2025 · 15:43
In this episode of Scaling Postgres, we discuss the role of Postgres in the US Treasury online attack, new releases of Postgres, optimizing application of streaming changes and a…
Feb 16, 2025 · 15:59
In this episode of Scaling Postgres, we discuss how data can flow from your OLTP to parquet files for analytics, parallel queries, view inlining and partitioning advice. To get…
Feb 9, 2025 · 14:32
In this episode of Scaling Postgres, we discuss how you can always optimize more, avoiding deadlocks, casting & indexes and pg_hint_plan best practices. To get the show notes as…
Feb 2, 2025 · 16:55
In this episode of Scaling Postgres, we talk about some features you may want to avoid like commit_delay, index_cleanup off, & logon triggers, a way to detect a table rewrite and…
Jan 26, 2025 · 19:09
In this episode of Scaling Postgres, we discuss our seven year anniversary, better pg_search performance, reducing table locks, not valid constraints and better group by…
Jan 19, 2025 · 15:24
In this episode of Scaling Postgres, we discuss the dangers of temporary tables, better transparent data encryption, pig the extension wizard, and table level lock…
Jan 12, 2025 · 12:28
In this episode of Scaling Postgres, we discuss whether the future of containers and Postgres, UUIDv7 commit, and a pg_duckdb interview. To get the show notes as well as get…
Dec 22, 2024 · 14:47
In this episode of Scaling Postgres, we discuss the new pg_incremental extension for processing data pipelines, a set of Postgres monitoring queries, handling alter table retries…
Dec 15, 2024 · 15:47
In this episode of Scaling Postgres, we discuss things I do not do such as use default partitions, play column Tetris, ELT using special data types or create 7+ millions tables…
Dec 8, 2024 · 17:02
In this episode of Scaling Postgres, we discuss OrioleDB getting Postgres over 5 times faster, historical OLAP performance, efficient queries and whether you should us…
Dec 1, 2024 · 17:38
In this episode of Scaling Postgres, we discuss new releases, collation speed, ZFS performance, insert benchmarking and pglz vs. lz4 performance. To get the show notes as well as…
Nov 24, 2024 · 18:50
In this episode of Scaling Postgres, we discuss new Postgres releases and an out-of-band release to address issues, increasing insert performance by 2X, pg_search benchmarks and…
Nov 17, 2024 · 13:19
In this episode of Scaling Postgres, we discuss the read and write performance of Postgres on ZFS, handling URL text identifiers in the database, denormalization and a new…
Nov 10, 2024 · 14:15
In this episode of Scaling Postgres, we discuss the future of Postgres upgrades, the usefulness of pg_dump, partitioning with minimal downtime and limitless Aurora. To get the…
Nov 3, 2024 · 16:39
In this episode of Scaling Postgres, we discuss whether you need a vectorizer, different ways to bin or bucket timestamps, addressing a bad plan and advanced psql. To get the…
Oct 27, 2024 · 11:32
In this episode of Scaling Postgres, we discuss pg_parquet allowing Postgres to read and write parquet files, other useful extensions, open source bounties, and Postgres gotchas.…
Oct 20, 2024 · 17:03
In this episode of Scaling Postgres, we discuss the JSON goodies in Postgres 17, trigger recursion, pg_dump as backup and pg_timeseries columnar performance. To get the show…
Oct 13, 2024 · 14:19
In this episode of Scaling Postgres, we discuss how one query runs 77 times faster in Postgres 17, a detailed Postgres 17 performance webinar, using logical replication fail over…
Listen in the Podli app 🎧
Follow your favourite podcasts, listen offline and in the car with CarPlay and Android Auto, and always pick up where you left off. Free to try.
Your podcast? Get the Podli badge for your site
