Skip to content
Sign in
Artwork for Postgres FM
TechnologyNewsTech News

Postgres FM

Nikolay Samokhvalov and Michael Christofides

A weekly podcast about all things PostgreSQL

Play
Open in
  • 27 episodes
  • weekly
  • Avg 45 min
  • English

Episodes 27

NewestOldestLongest
All7Unplayed7In progress0Played0
Counted on this page — what you have heard stays on this device, so it is not something the list can be paged by.
  • #173
    March 6 · 42 min

    Plan flips

    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 Clerk https://clerk.com/blog/2026-02-19-system-outage-postmortem The real cost of random I/O (blog post by Tomas Vondra) https://vondra.me/posts/the-real-cost-of-random-io autovacuum_analyze_scale_factor https://www.postgresql.org/docs/current/runtime-config-vacuum.html#GUC-AUTOVACUUM-ANALYZE-SCALE-FACTOR default_statistics_target https://www.postgresql.org/docs/current/runtime-config-query.html#GUC-DEFAULT-STATISTICS-TARGET pg_hint_plan https://github.com/ossc-db/pg_hint_plan Aurora PostgreSQL query plan management https://docs.aws.amazon.comAmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.Optimize.Start.html pg_stat_plans https://github.com/pganalyze/pg_stat_plans pg_plan_alternatives https://jnidzwetzki.github.io/2026/03/04/pg-plan-alternatives.html Waiting for Postgres 19: Better Planner Hints with Path Generation Strategies https://pganalyze.com/blog/5mins-postgres-19-better-planner-hints ~~~ What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc! ~~~ Postgres FM is produced by: Michael Christofides, founder of pgMustard Nikolay Samokhvalov, founder of Postgres.ai With credit to: Jessie Draws for the elephant artwork

    • Transcript
  • #172
    February 20 · 32 min

    pg_ash

    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 pg_wait_sampling https://github.com/postgrespro/pg_wait_sampling Amazon RDS performance insights https://aws.amazon.com/rds/performance-insights Our episode on wait events https://postgres.fm/episodes/wait-events pg-flight-recorder https://github.com/dventimisupabase/pg-flight-recorder pg_profile https://github.com/zubkov-andrei/pg_profile pg_cron https://github.com/citusdata/pg_cron ~~~ What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc! ~~~ Postgres FM is produced by: Michael Christofides, founder of pgMustard Nikolay Samokhvalov, founder of Postgres.ai With credit to: Jessie Draws for the elephant artwork

    • Transcript
  • #171
    February 13 · 36 min

    Comments and metadata

    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 https://www.postgresql.org/docs/current/sql-comment.html Query comment syntax (from an old version of the docs) https://www.postgresql.org/docs/7.0/syntax519.htm SQL Comments, Please! (Post by Markus Winand) https://modern-sql.com/caniuse/comments “While C-style block comments are passed to the server for processing and removal, SQL-standard comments are removed by psql.” https://www.postgresql.org/docs/current/app-psql.html marginalia https://github.com/basecamp/marginalia track_activity_query_size https://www.postgresql.org/docs/current/runtime-config-statistics.html#GUC-TRACK-ACTIVITY-QUERY-SIZE Custom Properties for Database Objects Using SECURITY LABELS (post by Andrei Lepikhov) https://www.pgedge.com/blog/custom-properties-for-postgresql-database-objects-without-core-patches ~~~ What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc! ~~~ Postgres FM is produced by: Michael Christofides, founder of pgMustard Nikolay Samokhvalov, founder of Postgres.ai With credit to: Jessie Draws for the elephant artwork

    • Transcript
  • #170
    January 23 · 44 min

    PgDog update

    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 first PgDog episode (March 2025) https://postgres.fm/episodes/pgdog Sharding pgvector (blog post by Lev) https://pgdog.dev/blog/sharding-pgvector Prepared statements and partitioned table lock explosion (series by Nik) https://postgres.ai/blog/20251028-postgres-marathon-2-009 ~~~ What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc! ~~~ Postgres FM is produced by: Michael Christofides, founder of pgMustard Nikolay Samokhvalov, founder of Postgres.ai With credit to: Jessie Draws for the elephant artwork

    • Transcript
  • #169
    January 16 · 57 min

    RegreSQL

    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 https://postgres.fm/people/radim-marek boringSQL https://boringsql.com RegreSQL: Regression Testing for PostgreSQL Queries (blog post by Radim) https://boringsql.com/posts/regresql-testing-queries Discussion on Hacker News https://news.ycombinator.com/item?id=45924619 Radim’s fork of RegreSQL on GitHub https://github.com/boringSQL/regresql Original RegreSQL on GitHub (by Dimitri Fontaine) https://github.com/dimitri/regresql The Art of PostgreSQL (book) https://theartofpostgresql.com How to make the non-production Postgres planner behave like in production (how-to post by Nik) https://postgres.ai/docs/postgres-howtos/performance-optimization/query-tuning/how-to-imitate-production-planner Just because you’re getting an index scan, doesn't mean you can’t do better! (Blog post by Michael) https://www.pgmustard.com/blog/index-scan-doesnt-mean-its-fast boringSQL Labs https://labs.boringsql.com ~~~ What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc! ~~~ Postgres FM is produced by: Michael Christofides, founder of pgMustard Nikolay Samokhvalov, founder of Postgres.ai With credit to: Jessie Draws for the elephant artwork

    • Transcript
  • #168
    January 2 · 47 min

    Postgres year in review 2025

    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 https://www.postgresql.org/docs/18/release-18.html Our episode on Postgres 18 https://postgres.fm/episodes/postgres-18 LWLock:LockManager benchmarks for Postgres 18 (blog post by Nik) https://postgres.ai/blog/20251009-postgres-marathon-2-005 PostgreSQL bug tied to zero-day attack on US Treasury https://www.theregister.com/2025/02/14/postgresql_bug_treasury PgDog episode https://postgres.fm/episodes/pgdog Multigres episode https://postgres.fm/episodes/multigres Neki announcement https://planetscale.com/blog/announcing-neki Our 100TB episode from 2024 https://postgres.fm/episodes/to-100tb-and-beyond PlanetScale for Postgres https://planetscale.com/blog/planetscale-for-postgres Oracle's MySQL job cuts https://www.theregister.com/2025/09/11/oracle_slammed_for_mysql_job Amazon Aurora DSQL is now generally available https://aws.amazon.com/about-aws/whats-new/2025/05/amazon-aurora-dsql-generally-available Announcing Azure HorizonDB https://techcommunity.microsoft.com/blog/adforpostgresql/announcing-azure-horizondb/4469710 Lessons from Replit and Tiger Data on Storage for Agentic Experimentation https://www.tigerdata.com/blog/lessons-replit-tiger-data-storage-agentic-experimentation Instant database clones with PostgreSQL 18 https://boringsql.com/posts/instant-database-clones turbopuffer episode https://postgres.fm/episodes/turbopuffer Crunchy joins Snowflake https://www.crunchydata.com/blog/crunchy-data-joins-snowflake Neon joins Databricks https://neon.com/blog/neon-and-databricks ~~~ What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc! ~~~ Postgres FM is produced by: Michael Christofides, founder of pgMustard Nikolay Samokhvalov, founder of Postgres.ai With credit to: Jessie Draws for the elephant artwork

    • Transcript
  • #167
    Dec 19, 2025 · 31 min

    Archiving

    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 https://www.youtube.com/watch?v=KFRK8PiIvTg&lc=UgyiFrO37gEgUaVhRgN4AaABAg Our episode on “Is pg_dump a backup tool?” https://postgres.fm/episodes/is-pg_dump-a-backup-tool ~~~ What did you like or not like? What should we discuss next time? Let us know via a YouTube comment, on social media, or by commenting on our Google doc! ~~~ Postgres FM is produced by: Michael Christofides, founder of pgMustard Nikolay Samokhvalov, founder of Postgres.ai With credit to: Jessie Draws for the elephant artwork

    • Transcript
Showing 21–27 of 27 episodes