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
Postgres FM artwork

Podcast

Postgres FM

Nikolay Samokhvalov and Michael Christofides

Technology · 197 episodes
Follow

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

Subscribe+ Add a creditShare

A weekly podcast about all things PostgreSQL

Listen on
  • Apple Podcasts
  • Find on Spotify
EpisodesPeoplePostsSubscribe

Is this your show? Claim this page

Information

Creator
Nikolay Samokhvalov and Michael Christofides
Category
Technology
Years active
2022 to 2026
Episodes
197
Copyright
© 2026 Nikolay Samokhvalov and Michael Christofides

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

  • Nikolay SamokhvalovHost, 188 episodesFeed-stated
  • Michael ChristofidesHost, 186 episodesFeed-stated

Guests

48 guests
  • Peter ZaitsevGuest, Peter ZaitsevFeed-stated
  • Alicja KucharczykGuest, pgBadgerFeed-stated
  • Jonathan S. KatzGuest, pgvectorFeed-stated
  • Chelsea DoleGuest, BloatFeed-stated
  • Markus WinandGuest, Modern SQLFeed-stated
  • Andrew AtkinsonGuest, Rails + PostgresFeed-stated
  • Sai SrirampurGuest, 2 episodesFeed-stated
  • Claire GiordanoGuest, Sponsoring the communityFeed-stated
  • Derk van VeenGuest, To 100TB, and beyond!Feed-stated
  • Sammy SteeleGuest, To 100TB, and beyond!Feed-stated
  • Arka GanguliGuest, To 100TB, and beyond!Feed-stated
  • Matvey AryeGuest, pgvectorscaleFeed-stated
  • John PruittGuest, pgvectorscaleFeed-stated
  • Melanie PlagemanGuest, Getting started with benchmarkingFeed-stated
  • Haki BenitaGuest, Get or CreateFeed-stated
  • Peter GeogheganGuest, Skip scanFeed-stated
  • Alexander KukushkinGuest, PatroniFeed-stated
  • Robert HaasGuest, Is pg_dump a backup tool?Feed-stated
  • Gülçin Yıldırım JelínekGuest, Is pg_dump a backup tool?Feed-stated
  • Lukas EderGuest, jOOQFeed-stated
  • Jelte Fennema-NioGuest, pg_duckdbFeed-stated
  • Joe SciarrinoGuest, pg_duckdbFeed-stated
  • Antonín HouskaGuest, pg_squeezeFeed-stated
  • Franck PachotGuest, SQL vs NoSQLFeed-stated
  • Lev KokotovGuest, 2 episodesFeed-stated
  • Tomas VondraGuest, Performance cliffsFeed-stated
  • Gwen ShapiraGuest, Multi-tenant optionsFeed-stated
  • Sugu SougoumaraneGuest, MultigresFeed-stated
  • Nate BrennandGuest, MultiXact member space exhaustionFeed-stated
  • Andrew JohnsonGuest, MultiXact member space exhaustionFeed-stated
  • Simon EskildsenGuest, turbopufferFeed-stated
  • Harry BrundageGuest, Gadget's use of PostgresFeed-stated
  • Radim MarekGuest, 2 episodesFeed-stated
  • Paul RamseyGuest, PostGISFeed-stated
  • Regina ObeGuest, PostGISFeed-stated
  • Bruce MomjianGuest, What’s Missing in Postgres?Feed-stated
  • Dmitry FominGuest, pg_wait_tracerFeed-stated
  • David VentimigliaGuest, pg_flight_recorderFeed-stated
  • David SteeleGuest, pgBackRestFeed-stated
  • Fabrízio de Royes MelloGuest, pg_stat_logFeed-stated
  • Qian LiGuest, DBOSFeed-stated
  • Peter KraftGuest, DBOSFeed-stated
  • Tudor GolubencoGuest, XataFeed-stated
  • Michael MalisGuest, pgrustFeed-stated
  • Shaun ThomasGuest, Estimating work_memFeed-stated
  • Salma El-SayedGuest, GSoC B-Tree MergeFeed-stated
  • Kirk WolakGuest, 4 episodesFeed-stated
  • Álvaro Hernández TortosaGuest, 2 episodesFeed-stated
Showing 5 of 48

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

197 episodes
197 episodes
  1. Postgres 19

    Nov 19, 202653 minAudio

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

    Credit the people on this episode

  2. The hidden costs of CREATE TEMP TABLE

    Nov 13, 202639 minAudio

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

    Credit the people on this episode

  3. Extensions on demand

    Nov 6, 20261 hr 9 minAudio

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

    Credit the people on this episode

  4. UUIDv4 vs UUIDv7

    Oct 30, 202648 minAudio

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

    Credit the people on this episode

  5. Dump/restore done. Now what?

    Oct 23, 202651 minAudio

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

    Credit the people on this episode

  6. Citus + StackGres

    Oct 16, 202659 minAudio

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

    Credit the people on this episode

  7. GSoC B-Tree Merge

    Sep 25, 202649 minAudio

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

    Credit the people on this episode

  8. ClickHouse Managed Postgres

    Sep 18, 202643 minAudio

    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-srirampur ClickHouse Managed...

    Credit the people on this episode

  9. hot_standby_feedback

    Sep 11, 202639 minAudio

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

    Credit the people on this episode

  10. Estimating work_mem

    Aug 21, 202650 minAudio

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

    Credit the people on this episode

  11. pgrust

    Aug 14, 202635 minAudio

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

    Credit the people on this episode

  12. MVCC

    Aug 7, 202644 minAudio

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

    Credit the people on this episode

  13. Xata

    Jul 31, 202646 minAudio

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

    Credit the people on this episode

  14. DBOS

    Jul 24, 202639 minAudio

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

    Credit the people on this episode

  15. pg_stat_log

    Jul 17, 202644 minAudio

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

    Credit the people on this episode

  16. pgBackRest

    Jul 3, 20261 hr 13 minAudio

    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-steele pgBackRest https://pgbackrest.org...

    Credit the people on this episode

  17. autovacuum

    May 29, 202646 minAudio

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

    Credit the people on this episode

  18. pg_flight_recorder

    May 15, 202643 minAudio

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

    Credit the people on this episode

  19. PgQue

    May 8, 202647 minAudio

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

    Credit the people on this episode

  20. pg_wait_tracer

    Apr 24, 202644 minAudio

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

    Credit the people on this episode

  21. Schema design checklist

    Apr 17, 202645 minAudio

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

    Credit the people on this episode

  22. What’s Missing in Postgres?

    Apr 3, 202644 minAudio

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

    Credit the people on this episode

  23. Long-running transactions

    Mar 27, 202648 minAudio

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

    Credit the people on this episode

  24. PostGIS

    Mar 13, 202653 minAudio

    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-obe Paul Ramsey...

    Credit the people on this episode

  25. Plan flips

    Mar 6, 202643 minAudio

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

    Credit the people on this episode

  26. pg_ash

    Feb 20, 202632 minAudio

    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 https://github.com/NikolayS/pg_ash...

    Credit the people on this episode

  27. Comments and metadata

    Feb 13, 202636 minAudio

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

    Credit the people on this episode

  28. PgDog update

    Jan 23, 202644 minAudio

    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-kokotov PgDog https://github.com/pgdogdev/pgdog Our...

    Credit the people on this episode

  29. RegreSQL

    Jan 16, 202658 minAudio

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

    Credit the people on this episode

  30. Postgres year in review 2025

    Jan 2, 202647 minAudio

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

    Credit the people on this episode

  31. Archiving

    Dec 19, 202531 minAudio

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

    Credit the people on this episode

  32. max_connections vs migrations

    Dec 5, 202545 minAudio

    Nik and Michael discuss max_connections, especially in the context of increasing it to solve problems like migrations intermittently failing(!) Here are some links to things they mentioned: max_connections...

    Credit the people on this episode

  33. What's new in EXPLAIN

    Nov 21, 202545 minAudio

    Nik and Michael discuss the various changes to EXPLAIN that arrived in Postgres 18. Here are some links to things they mentioned: EXPLAIN (official docs) https://www.postgresql.org/docs/current/sql-explain.html Using...

    Credit the people on this episode

  34. Tens of TB per hour

    Nov 14, 202539 minAudio

    Nik talks Michael through a recent benchmark he worked with Maxim Boguk on, to see how quickly they could provision a replica. Here are some links to things they mentioned: Ultra-fast replica creation with pgBackRest...

    Credit the people on this episode

  35. Gapless sequences

    Oct 31, 202540 minAudio

    Nik and Michael discuss the concept of gapless sequences - when you might want one, why sequences in Postgres can have gaps, and an idea or two if you do want them. And one quick clarification: changing the CACHE option...

    Credit the people on this episode

  36. LWLocks

    Oct 17, 202538 minAudio

    Nik and Michael discuss lightweight locks in Postgres - how they differ to (heavier) locks, some occasions they can be troublesome, and some resources for working out what to do if you hit issues. Here are some links to...

    Credit the people on this episode

  37. User management

    Oct 3, 202539 minAudio

    Nik and Michael discuss user management in Postgres - how roles work, making administration easier, setting passwords, and avoiding them being logged. Here are some links to things they mentioned: Roles...

    Credit the people on this episode

  38. Postgres 18

    Sep 26, 202556 minAudio

    Nik and Michael discuss the newly released Postgres 18 - the bigger things it includes, some of their personal highlights, and some thoughts towards the future. Here are some links to things they mentioned: Postgres 18...

    Credit the people on this episode

  39. Gadget's use of Postgres

    Sep 19, 202553 minAudio

    Nik and Michael are joined by Harry Brundage from Gadget to talk about their recent zero-downtime major version upgrade, how they use Postgres more generally, their dream database, and some challenges of providing...

    Credit the people on this episode

  40. turbopuffer

    Sep 12, 202550 minAudio

    Nik and Michael are joined by Simon Eskildsen from turbopuffer - among other things, they discuss ANN index types, tradeoffs that can make sense for search workloads, and when it can make sense to move search out of...

    Credit the people on this episode

  41. When not to use Postgres

    Sep 5, 202546 minAudio

    Nik and Michael discuss when not to use Postgres - specifically use cases where it still makes sense to store data in another system. Here are some links to things they mentioned: Just use Postgres (blog post by Ethan...

    Credit the people on this episode

  42. Disks

    Aug 29, 202546 minAudio

    Nik and Michael discuss disks in relation to Postgres - why they matter, how saturation can happen, some modern nuances, and how to prepare to avoid issues. Here are some links to things they mentioned: Nik’s tweet...

    Credit the people on this episode

  43. Multi-column indexes

    Aug 22, 202541 minAudio

    Nik and Michael discuss multi-column indexes in Postgres - what they are, how to think about them, and some guidance around using them effectively. Here are some links to things they mentioned: Multicolumn Indexes...

    Credit the people on this episode

  44. Self-driving Postgres

    Aug 15, 202559 minAudio

    Nikolay and Michael discuss self-driving Postgres - what it could mean, using self-driving cars as a reference, and ideas for things to build and optimize for in this area. Here are some links to things they mentioned:...

    Credit the people on this episode

  45. caSe-inSENsiTive

    Aug 8, 202526 minAudio

    Nikolay and Michael discuss case-insensitive data - when we want to treat columns as case-insensitive, and the pros and cons of using citext, functions like lower(), or a custom collation. Here are some links to things...

    Credit the people on this episode

  46. Monitoring from Postgres AI

    Jul 25, 202545 minAudio

    Nikolay talks to Michael about Postgres AI's new monitoring tool - what it is, how its different to other tools, and some of the thinking behind it. Here are some links to things they mentioned: postgres_ai monitoring...

    Credit the people on this episode

  47. MultiXact member space exhaustion

    Jul 18, 202556 minAudio

    Nikolay and Michael are joined by Andrew Johnson and Nate Brennand from Metronome to discuss MultiXact member space exhaustion - what it is, how they managed to hit it, and some tips to prevent running into it at scale....

    Credit the people on this episode

  48. Multigres

    Jul 11, 20251 hr 19 minAudio

    Nikolay and Michael are joined by Sugu Sougoumarane to discuss Multigres - a project he's joined Supabase to lead, building an adaptation of Vitess for Postgres! Here are some links to things they mentioned: Sugu...

    Credit the people on this episode

  49. Multi-tenant options

    Jun 20, 202550 minAudio

    Nikolay and Michael are joined by Gwen Shapira to discuss multi-tenant architectures - the high level options, the pros and cons of each, and how they're trying to help with Nile. Here are some links to things they...

    Credit the people on this episode

  50. Mean vs p99

    Jun 13, 202539 minAudio

    Nikolay and Michael discuss looking at queries by mean time - when it makes sense, why ordering by a percentile (like p99) might be better, and the merits of approximating percentiles in pg_stat_statements using the...

    Credit the people on this episode

  51. What to log

    Jun 6, 202549 minAudio

    Nikolay and Michael discuss logging in Postgres - mostly what to log, and why changing quite a few settings can pay off big time in the long term. Here are some links to things they mentioned: What to log...

    Credit the people on this episode

  52. How to move off RDS

    May 30, 202548 minAudio

    Nikolay and Michael discuss moving off managed services - when and why you might want to, and some tips on how for very large databases. Here are some links to things they mentioned: Patroni...

    Credit the people on this episode

  53. Locks

    May 23, 202539 minAudio

    Nikolay and Michael discuss heavyweight locks in Postgres - how to think about them, why you can't avoid them, and some tips for minimising issues. Here are some links to things they mentioned: Locking (docs)...

    Credit the people on this episode

  54. Top ten dangerous issues

    May 9, 202546 minAudio

    Nikolay and Michael discuss ten dangerous Postgres related issues - ones that might be painful enough to get onto the CTO and even CEOs desk, and then what you can do proactively. The ten issues discussed are: Heavy...

    Credit the people on this episode

  55. synchronous_commit

    May 2, 202551 minAudio

    Nikolay and Michael discuss synchronous_commit - what it means on single node setups, for synchronous replication setups, and the pros and cons of the different options for each. Here are some links to things they...

    Credit the people on this episode

  56. Managed service support

    Apr 25, 202536 minAudio

    Nikolay and Michael discuss managed service support - some tips on how to handle cases that aren't going well, tips for requesting features, whether to factor in support when choosing service provider, and whether to...

    Credit the people on this episode

  57. Time-series considerations

    Apr 11, 202543 minAudio

    Nikolay and Michael discuss time-series considerations for Postgres - including when it matters, some tips for avoiding issues, performance considerations, and more. Here are some links to things they mentioned: Time...

    Credit the people on this episode

  58. Performance cliffs

    Apr 4, 202538 minAudio

    Nikolay and Michael are joined by Tomas Vondra to discuss single query performance cliffs - what they are, why they happen, some things we can do to make them less likely or less severe, and some potential improvements...

    Credit the people on this episode

  59. PgDog

    Mar 28, 202549 minAudio

    Nikolay and Michael are joined by Lev Kokotov to discuss PgDog - including whether or when sharding is needed, the origin story (via PgCat), what's already supported, and what's coming next. Here are some links to...

    Credit the people on this episode

  60. Snapshots

    Mar 21, 202544 minAudio

    Nikolay talks Michael through using cloud snapshots - how they can be used to reduce RTO for huge Postgres setups, also to improve provisioning time, and some major catches to be aware of. Here are some links to things...

    Credit the people on this episode

Show moreShowing 60 of 197

Posts

No posts yet. Posts Postgres FM 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 Postgres FM 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

  • IndieRails artwork

    IndieRails

    Shares a person with this show

    79 episodes

    Updated Nov 19, 2026

  • 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