English-language podcasts

Postgres FM

Postgres 19

53 min

Listen through the publisher, then discuss the episode here or arrange an in-person Roundtable. Your city determines where to meet.

Roundtables are designed for groups of four, with a shared subject and room for everyone to speak. Come for discussion, with no dating expectation.

Tip: watch on YouTube. Since episode 193, the video shows charts and illustrations as we talk. https://youtu.be/VcDU-NRE3hI Michael, Nik, and Kirk discuss Postgres 19: why the release came in November and not in September, the features we like most, and what to check before you upgrade. We cover REPACK (CONCURRENTLY), LISTEN/NOTIFY with many listeners, autovacuum prioritization, plan advice, WAIT FOR LSN, new defaults, and how to test an upgrade now that AI makes testing cheaper. Here are some links to things we mentioned: Times are podcast times of the first mention. Main link [00:20:40] Postgres 19 for people who run it: PostgreSQL 19 RC2 vs 18.7 (DBLab Forge study brief, PostgresAI) https://console.postgres.ai/shared/brief/01a1e0e2-b826-73de-8300-9e56a1eb124c The release [00:01:55] PostgreSQL 19 release notes https://www.postgresql.org/docs/19/release-19.html [00:05:19] What LLMs do to PostgreSQL and DBAs (depesz, 2026-11-09) https://www.depesz.com/2026/11/09/what-llms-do-to-postgresql-and-dbas/ [00:07:54] scary patch contest (Robert Haas, pgsql-hackers, 2026-08-25) https://www.postgresql.org/message-id/CA%2BTgmob9NY6m0YNFTQ4nFH2d0iC9SQRruDYxfndGKKzh8OC80w%40mail.gmail.com [00:08:08] Are we reverting patches because of bugs found by AI? (Tomas Vondra, 2026-10-01) https://vondra.me/posts/are-we-reverting-patches-because-of-bugs-found-by-ai/ [00:08:22] pgroast, an adversarial reviewer for Postgres proposals https://github.com/NikolayS/pgroast Episodes we referred to [00:10:03] pg_squeeze, with Antonin Houska https://postgres.fm/episodes/pg_squeeze [00:16:58] The hidden costs of CREATE TEMP TABLE (last week) https://postgres.fm/episodes/the-hidden-costs-of-create-temp-table [00:17:21] DBOS, on LISTEN/NOTIFY at scale (its notes link the Recall.ai post) https://postgres.fm/episodes/dbos [00:36:53] Dump/restore done. Now what? (episode 193) https://postgres.fm/episodes/dump-restore-done-now-what REPACK [00:09:56] Add CONCURRENTLY option to REPACK (commit, Antonin Houska; based on pg_squeeze) https://github.com/postgres/postgres/commit/28d534e2ae0ac888b5460f977a10cd9bb017ef98 [00:13:37] What REPACK (CONCURRENTLY) costs while it runs (Radim Marek, boringSQL, 2026-09-28) https://boringsql.com/posts/repack-concurrently-costs/ LISTEN/NOTIFY and autovacuum [00:17:31] Optimize LISTEN/NOTIFY via shared channel map and direct advancement (commit, Joel Jacobson) https://github.com/postgres/postgres/commit/282b1cde9dedf456ecf02eb27caf086023a7bb71 [00:19:51] Add rudimentary table prioritization to autovacuum (commit, Nathan Bossart) https://github.com/postgres/postgres/commit/d7965d65fc5bb2139bc51c051c11428414c65160 Plan advice [00:22:13] Waiting for Postgres 19: Better Planner Hints with Path Generation Strategies (Lukas Fittl, 5mins of Postgres) https://pganalyze.com/blog/5mins-postgres-19-better-planner-hints Other features [00:27:52] jit: Change the default to off (commit, Jelte Fennema-Nio) https://github.com/postgres/postgres/commit/7f8c88c2b872cb74882ab93dcb05529dab2a10bc [00:30:16] WAIT FOR (docs) https://www.postgresql.org/docs/19/sql-wait.html [00:35:40] instrumentation: Use Time-Stamp Counter on x86-64 to lower overhead (commit, Lukas Fittl, Andres Freund, David Geier) https://github.com/postgres/postgres/commit/294520c44487ecaade7a6ea8781b973f9ed03909 Upgrade [00:40:58] pg_upgrade --check passes, then the upgrade fails (shihao zhong, pgsql-hackers, 2026-10-24) https://www.postgresql.org/message-id/CAGRkXqT%2B5%2BmQhoKZFTiM4yOZtVV%3DNW506vDwFtVeG%2BVmL_W5wQ%40mail.gmail.com [00:47:53] RegreSQL, catch query performance regressions (Radim Marek) https://github.com/boringSQL/regresql About the numbers on screen They come from the study brief above. Most are synthetic tests of setups we built; they are not failure or speed rates of real systems. All are for 19 RC2, not 19.0. CVEs per release: https://www.postgresql.org/support/security/ (snapshot 2026-11-18, 229 CVEs), grouped by release day from 2019 to 18.7; releases without a CVE count as 0. 18.7 fixed 52 and 18.6 fixed 28; 2019-2025 releases fixed 1.5 on average (median 1). Release credits: names in the release-notes acknowledgments of 12 to 19; commits in each development cycle (PostgreSQL git, data of 2026-11-11). REPACK (CONCURRENTLY): 19.0, 16 dedicated vCPU, 20,000,000-row table, 16 writer sessions; median of 3 runs per point (2 valid runs at the first point). LISTEN/NOTIFY: 1,000 listeners on their own channels, 4 notifiers, 8-vCPU dedicated host, median of 3 trials; our client was the limit, so 19 can go higher. Autovacuum order: one old table (age 1.65 billion) among 120 bloated tables, 16-vCPU dedicated host, median of 3 trials. Plan advice: advice generated for every query (always_store_advice_details), trivial query, small shared test host, 4 clients, 20 s, 2 trials; 11% against the modules off, 14% against them loaded and idle. JIT: 22 TPC-H-derived queries, scale factor 10, 32-vCPU dedicated host, 3 trials; per-query numbers are exploratory. JIT itself did not change; the default did. lz4 TOAST: insert of 200,000 jsonb documents of 16 KiB, 8-vCPU dedicated host, 3 trials. The table is 11.3% larger with lz4; if disk matters more, set default_toast_compression = pglz. Plan changes: 4,273 benchmark queries (263 templates; 220 stable on 18.7) planned on 18.7 and 19 RC2 with the same data and statistics; 61 of the 83 changed templates come from one planner commit (a tie-break), shown by a build without it. Notes (checked against the Postgres 19 RC2 source after recording) [00:21:...

Episode information is provided by the publisher. Listening takes place on the publisher’s service.

Listen at the source ↗

Featured places to meet in Palo Alto, CA

Explore these places and arrange a conversation through ThinkMatch.

City guide for Palo Alto, CA

More from Postgres FM

Postgres FM

The hidden costs of CREATE TEMP TABLE

39 min

Tip: watch on YouTube. Since episode 193, the video shows charts and illustrations as we talk. https://www.youtube.com/watch?v=gAdhpYewLZ8 Nik and Kirk discuss the hidden costs of CREATE TEMP TABLE: dead tuples and catalog bloat, and the shared invalidation queue that every session has to read. They cover why thousands of idle sessions make it much worse, what it looks like in wait events, and what to use instead. Here are some links to things they mentioned: Times are podcast times of the first mention. Main link [00:34:15] Temp tables in the request path: where the cliff is, and what LWLock:SInvalWrite really tells you (DBLab Forge brief, PostgresAI) https://console.postgres.ai/shared/brief/dfe99713-f5a8-483b-9aab-1606a883b75d Michael [00:00:44] Michael's post about taking a few months off (X) https://x.com/michristofides/status/2117283823314674021 Episodes [00:06:12] UUIDv4 vs UUIDv7 https://postgres.fm/episodes/uuidv4-vs-uuidv7 Postgres docs [00:01:32] CREATE TABLE, Compatibility:

Discuss this episode

Postgres FM

Extensions on demand

69 min

Tip: watch on YouTube. Since episode 193, the video shows charts and illustrations as we talk. https://www.youtube.com/watch?v=7oeAAqU00zk Nik and Kirk are joined by Álvaro Hernández to discuss how Postgres in containers gets its extensions: a fat image with all of them, extensions downloaded at run time, or StackGres Containers, built on DOCIR (Dynamic OCI Registry), which composes an image with only the extensions you ask for, on demand. They also discuss what this means for security, pinning versions, and major upgrades. Here are some links to things they mentioned: Times are podcast times of the first mention. Main link [00:18:54] Dynamic containers for PostgreSQL: what we measured (DBLab Forge brief, PostgresAI) https://console.postgres.ai/shared/brief/c501d438-b872-4705-89a6-bdab30ea1680 Álvaro and StackGres [00:00:25] Álvaro Hernández https://postgres.fm/people/alvaro-hernandez-tortosa [00:01:16] StackGres Containers (public beta; the images come from the registry host sgcr.io,

Discuss this episode

Community Poll

Youth sport should prioritize lasting participation over early selection of elite performers.

Share your view, then see how readers voted. No sign-in required. This poll is shared across stories.

Do you agree or disagree?

Choose one answer

Common Quandary

A Common Quandary to discuss

Another conversation to explore, separate from this news story.

You can clone the best dog you ever had. Would you?

After a beloved dog dies, its owner can afford to have it cloned. The procedure is legal and improving, but it uses animals as surrogates and will not recreate the original dog's memories or personality.

What do our obligations to animals permit us to create for our own comfort?

Explore this quandary