Zum Inhalt springen
Postgres FM

Postgres FM

NeuThe hidden costs of CREATE TEMP TABLE13.11.2026 · 39 Min.
Folgen
196
Erscheint
wöchentlich
Letzte Folge
13. Nov. 2026

Über den Podcast

A weekly podcast about all things PostgreSQL

Mitwirkende

Folgen 196

  1. The hidden costs of CREATE TEMP TABLE

    39 Min.Folge 196

    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 …

  2. Extensions on demand

    1 Std. 9 Min.Folge 195

    Mit Álvaro Hernández Tortosa und Kirk Wolak

    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 …

  3. UUIDv4 vs UUIDv7

    48 Min.Folge 194

    Mit Kirk Wolak

    Tip: watch on YouTube. Since episode 193, the video shows charts and illustrations as we talk. https://www.youtube.com/watch?v=gf8e3JkQ_8M Nik is joined by Kirk Wolak to discuss what a random UUIDv4 primary key …

  4. Dump/restore done. Now what?

    51 Min.Folge 193

    Mit Kirk Wolak

    Nik is joined by Kirk Wolak, Software Architect at KiraSoft, to discuss what a database still needs after pg_restore finishes and before it takes production traffic — what pg_dump and pg_restore leave behind …

  5. Citus + StackGres

    59 Min.Folge 192

    Mit Álvaro Hernández Tortosa

    Nik and Michael are joined by Álvaro Hernández to discuss sharding Postgres with Citus and StackGres, especially the new query router support that has been added very recently. Here are some links to things …

  6. GSoC B-Tree Merge

    49 Min.Folge 191

    Mit Kirk Wolak und Salma El-Sayed

    Nik and Michael are joined by Salma El-Sayed and Kirk Wolak to discuss their in-progress and very ambitious Google Summer of Code project around adding Btree Merge support to Postgres. Here are some links to …

  7. ClickHouse Managed Postgres

    43 Min.Folge 190

    Mit Sai Srirampur

    Nik and Michael are joined by Sai Srirampur to discuss ClickHouse's new managed Postgres service. Here are some links to things they mentioned: Sai Srirampur https://postgres.fm/people/sai-srirampurClickHouse …

  8. hot_standby_feedback

    39 Min.Folge 189

    Nik and Michael discuss hot_standby_feedback — what it controls, whether and when read replicas should be changed to on, and other settings you can change to help too. Here are some links to things they …

  9. Estimating work_mem

    50 Min.Folge 188

    Mit Shaun Thomas

    Nik and Michael are joined by Shaun Thomas to discuss estimating work_mem, memory management in general, and writing an extension to help. Here are some links to things they mentioned: Shaun Thomas …

  10. pgrust

    35 Min.Folge 187

    Mit Michael Malis

    Nik and Michael are joined by Michael Malis, co-creator of pgrust, to discuss their Postgres rewrite, including reliability problems, compatibility testing, faster analytics, and a new JIT-compiled query …

  11. MVCC

    44 Min.Folge 186

    Mit Radim Marek

    Nik and Michael are joined by Radim Marek to discuss MVCC, including his recent article on how Postgres chose to implement it compared to other systems. Here are some links to things they mentioned: Radim Marek …

  12. Xata

    46 Min.Folge 185

    Mit Tudor Golubenco

    Nik and Michael are joined by Tudor Golubenco, CTO of Xata, to discuss their architecture, progress, and open source tooling. Here are some links to things they mentioned: Tudor Golubenco …

  13. DBOS

    39 Min.Folge 184

    Mit Peter Kraft und Qian Li

    Nik and Michael are joined by Qian Li and Peter Kraft to talk about DBOS, an open source platform for durable workflows built on Postgres. Here are some links to things they mentioned: Qian Li …

  14. pg_stat_log

    44 Min.Folge 183

    Mit Fabrízio de Royes Mello

    Nik and Michael are joined by Fabrízio Mello to discuss his new extension pg_stat_log.Here are some links to things they mentioned: Fabrízio Mello https://postgres.fm/people/fabrizio-de-royes-melloTimbira …

  15. pgBackRest

    1 Std. 13 Min.Folge 182

    Mit David Steele

    Nik and Michael are joined by David Steele to talk all things pgBackRest. Here are some links to things they mentioned: David Steele https://postgres.fm/people/david-steelepgBackRest …

  16. autovacuum

    46 Min.Folge 181

    Nik and Michael discuss autovacuum, including what it does, and the basics of why and how to tune it. Here are some links to things they mentioned: autovacuum …

  17. pg_flight_recorder

    43 Min.Folge 180

    Mit David Ventimiglia

    Nik and Michael are joined by David Ventimiglia to discuss pg_flight_recorder, a new tool he created for monitoring a Postgres database from within. Here are some links to things they mentioned: David …

  18. PgQue

    47 Min.Folge 179

    Nik and Michael discuss Nik's new project PgQue, a descendent of Skype's PgQ, for running queue-like workloads in Postgres. Here are some links to things they mentioned: Our first episode on Queues in Postgres …

  19. pg_wait_tracer

    44 Min.Folge 178

    Mit Dmitry Fomin

    Nik and Michael are joined by Dmitry Fomin to discuss his new tool pg_wait_tracer, as well as changes that could be made to core to allow wait event tracing with lower overhead, and on managed services. Here …

  20. Schema design checklist

    45 Min.Folge 177

    Nik and Michael discuss a list of things to check when designing new schema in Postgres. Here are some links to things they mentioned:Use BIGINT in Postgres (blog post by Ryan Lambert) …

  21. What’s Missing in Postgres?

    44 Min.Folge 176

    Mit Bruce Momjian

    Nik and Michael are joined by Bruce Momjian to discuss his new talk "What’s Missing in Postgres?" Here are some links to things they mentioned: Bruce Momjian https://postgres.fm/people/bruce-momjianEDB …

  22. Long-running transactions

    48 Min.Folge 175

    Nik and Michael discuss long-running transactions, including when they're harmless, when they cause issues, and how to mitigate those issues. Here are some links to things they mentioned: transaction_timeout …

  23. PostGIS

    53 Min.Folge 174

    Mit Regina Obe und Paul Ramsey

    Nik and Michael are joined by Regina Obe and Paul Ramsey to discuss PostGIS. Here are some links to things they mentioned:Regina Obe https://postgres.fm/people/regina-obePaul Ramsey …

  24. Plan flips

    43 Min.Folge 173

    Nik and Michael discuss query plan flips in Postgres — what they are, some causes, mitigations, longer term solutions, and the recent outage at Clerk. Here are some links to things they mentioned: Recent …

  25. pg_ash

    32 Min.Folge 172

    Nik and Michael discuss pg_ash — a new tool (not extension!) from Nik that samples and stores wait events from pg_stat_activity. Here are some links to things they mentioned: pg_ash …

  26. Comments and metadata

    36 Min.Folge 171

    Nik and Michael discuss query level comments, object level comments, and another way of adding object level metadata. Here are some links to things they mentioned: Object comments …

  27. PgDog update

    44 Min.Folge 170

    Mit Lev Kokotov

    Nik and Michael are joined by Lev Kokotov for an update on all things PgDog. Here are some links to things they mentioned:Lev Kokotov https://postgres.fm/people/lev-kokotovPgDog …

  28. RegreSQL

    58 Min.Folge 169

    Mit Radim Marek

    Nik and Michael are joined by Radim Marek from boringSQL to talk about RegreSQL, a regression testing tool for SQL queries they forked and improved recently. Here are some links to things they mentioned:Radim …

  29. Postgres year in review 2025

    47 Min.Folge 168

    Nik and Michael discuss the events and trends they thought were most important in the Postgres ecosystem in 2025. Here are some links to things they mentioned: Postgres 18 release notes …

  30. Archiving

    31 Min.Folge 167

    Nik and Michael discuss a listener question about archiving a database. Here are some links to things they mentioned: Listener request to talk about archiving …

Hier stehen die neuesten 40 von 196 Folgen. Ältere Folgen findest du im Feed des Podcasts.

Ist das dein Podcast?

Bestätige es mit einem Eintrag in deinem Feed: Du bekommst hier einen Code, trägst ihn als podcast:txt in den Kanal deines Feeds ein, und wir prüfen ihn. Danach steht dein Podcast als „verifiziert“ bei SoundNode.

Einstellungen

Darstellung

Sprache

Bestimmt, welche Sender dir auf der Startseite zuerst gezeigt werden.

Verlauf

Zuletzt gehörte Sender und Folgen und deine letzten Suchen liegen nur in diesem Browser.

Hinweise

Ein kurzer Hinweis, wenn ein Podcast, dem du folgst, eine neue Folge hat. Einzelne Podcasts stellst du über die Glocke auf ihrer Seite ab.

Konto

Favoriten speichern – in der App und auf der Website.

Tastenkürzel

/
Suche öffnen
Leertaste
Abspielen oder anhalten
← →
Im Player: 15 s zurück, 30 s vor (Folgen) · im Regal: nächste Kachel
↑ ↓
Im Regal: Ziel innerhalb der Kachel
Pos1 / Ende
Im Regal: erste bzw. letzte Kachel
Esc
Fenster oder Menü schließen
?
Diese Übersicht
Läuft gerade

Zur Senderseite

Als Nächstes

    Folgen mit „Als Nächstes“ vormerken – sie laufen nach der aktuellen Folge.