English-language podcasts

Postgres FM

Extensions on demand

69 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://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, and the demo used sgcr.dev, a dev instance) https://stackgres.io/containers [00:14:52] StackGres https://stackgres.io (https://stackgres.io/) [00:20:55] PostgreSQL extensions in StackGres, loaded into running pods (docs) https://stackgres.io/doc/latest/features/extensions/ [00:24:28] StackGres extensions cache, experimental (docs) https://stackgres.io/doc/latest/administration/extensions/cache/ [01:04:08] Why Postgres extensions should be packaged and distributed as OCI images (Álvaro Hernández, 2024) https://ongres.com/blog/why-postgres-extensions-should-be-distributed-and-packaged-as-oci-images/ Episodes [00:00:25] Our previous episode with Álvaro: Citus + StackGres https://postgres.fm/episodes/citus-stackgres Hacking sessions [00:31:33] Hacking Postgres sessions with Andrey, Kirk and Nik (YouTube playlist, PostgresTV) https://www.youtube.com/playlist?list=PLH8y1BNPAKjKDdJA7sDmFWUkbbYux3TRz Postgres and extensions [00:38:51] extension_control_path, new in Postgres 18 (docs) https://www.postgresql.org/docs/18/runtime-config-client.html#GUC-EXTENSION-CONTROL-PATH (https://www.postgresql.org/docs/18/runtime-config-client.html) [00:50:56] pg_background https://github.com/vibhorkum/pg_background [00:50:58] plsh (Peter Eisentraut) https://github.com/petere/plsh [01:02:58] PGXN, the PostgreSQL Extension Network https://pgxn.org (https://pgxn.org/) [01:04:40] POC: Distributing Trunk binaries via OCI (David E. Wheeler, 2024) https://justatheory.com/2024/06/trunk-oci-poc/ [01:05:12] Anarchy in the Database: a survey and evaluation of DBMS extensibility (Kim, Slot, Andersen, Pavlo, VLDB 2025; tests extensions in pairs) https://www.vldb.org/pvldb/vol18/p1962-kim.pdf Containers [00:01:22] OCI image format specification https://github.com/opencontainers/image-spec [00:41:19] Spilo (Zalando), one Postgres image with several major versions https://github.com/zalando/spilo [01:05:43] Testcontainers, PostgreSQL module https://testcontainers.com/modules/postgresql/ Other [00:36:32] Mitchell Hashimoto on never updating dependencies unless it breaks (post on X, 2026-05-20) https://x.com/mitchellh/status/2057171518027887035 ~~~ What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, (https://postgres.fm/people) or by commenting on our Google doc (https://docs.google.com/document/d/1PNGSn_d0A7gTR4C0p6geQyHOTgdpitKCRvafCNnT-44/edit)! ~~~ Postgres FM is produced by: Michael Christofides, founder of pgMustard (https://pgmustard.com/) Nikolay Samokhvalov, founder of PostgresAI (https://postgres.ai/) With credit to: Jessie Draws for the elephant artwork Intro and outro music: our own arrangement of Apple Loops from GarageBand (royalty-free under the GarageBand licence)

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

Postgres 19

53 min

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

Discuss this episode

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

Community Poll

Emergency powers should expire automatically unless publicly renewed.

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.

Your friend asks for an honest review after every date. Do their dates deserve privacy?

A close friend sends detailed post-date reports and expects your advice about every message, kiss, and awkward silence. One recent date is someone you know professionally, who would be embarrassed to learn how much you have heard.

Where does friendship's need for advice become gossip about an unsuspecting person?

Explore this quandary