Postgres FM

A weekly podcast about all things PostgreSQL — by @michristofides and @samokhvalov. Also at

[Postgres FM @PostgresFM]

New episode: "ClickHouse Managed Postgres"

Nik and Michael are joined by @saisrirampur to discuss @ClickHouseDB's new managed Postgres service.

🎧️ https://t.co/ukrRTVdDTk

📺️ https://t.co/lVHKSxk6qd

[Postgres FM @PostgresFM]

New episode: "hot_standby_feedback"

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.

🎧 https://t.co/juHzjapelp

📺 https://t.co/w05mZ9Jy7X

[Postgres FM @PostgresFM]

New episode: "Estimating work_mem"

Nik and Michael are joined by Shaun Thomas (@BonesMoses) to discuss estimating work_mem, memory management in general, and writing an extension to help.

🎧 https://t.co/yjSRmatQRz

📷 https://t.co/wwqGk5VGQ0

[Postgres FM @PostgresFM]

New episode: "pgrust"

Nik and Michael are joined by @mmalisper, co-creator of pgrust, to discuss their Postgres rewrite, including reliability problems, compatibility testing, and a new JIT-compiled query engine.

🎧 https://t.co/NPiwI0QIUd

📺 https://t.co/C2oaALLY75

[Postgres FM @PostgresFM]

New episode: "MVCC"

Nik and Michael are joined by Radim Marek from boringSQL to discuss MVCC, including his recent article on how Postgres chose to implement it compared to other systems.

🎧️️️ https://t.co/B69CZQKNSz

📺️️️ https://t.co/IpdFcfjZfS

[Postgres FM @PostgresFM]

New episode: "Xata"

Nik and Michael are joined by @tudor_g, CTO of @xata, to discuss their architecture, progress, and open source tooling.

🎧️️ https://t.co/4o4gTorvKB

📺️️ https://t.co/0Pk1LAFlt5

[Postgres FM @PostgresFM]

New episode: "DBOS"

Nik and Michael are joined by @qianl_cs and @petereliaskraft to talk about @DBOS_Inc, an open source platform for durable workflows built on Postgres.

🎧️ https://t.co/0Ymv8rA65y

📺️ https://t.co/3YByKTMR8I

[Postgres FM @PostgresFM]

New episode: "pg_stat_log"

Nik and Michael are joined by @fabriziomello to discuss his new extension pg_stat_log.

🎧 https://t.co/5oVzHbyZFf

📺 https://t.co/eU1jTOcRpu

[Postgres FM @PostgresFM]

New episode: "pgBackRest"

Nik and Michael are joined by David Steele to talk all things pgBackRest.

🎧 https://t.co/pfcpnwufbe

📺 https://t.co/suoApnOSbm

[Postgres FM @PostgresFM]

Due to travelling and holidays we’re taking a few weeks off, but we’re excited to be back after that!

[Postgres FM @PostgresFM]

New episode: "autovacuum"

Nik and Michael discuss autovacuum, including what it does, and the basics of why and how to tune it.

🎧 https://t.co/6qqZbCkZzS

📺 https://t.co/fsJbHfXjol

[Postgres FM @PostgresFM]

New episode: "pg_flight_recorder"

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.

🎧 https://t.co/bVZCQnaIHx

📺 https://t.co/bZYjYladRw

[Postgres FM @PostgresFM]

New episode: "PgQue"

Nik and Michael discuss Nik's new project PgQue, a descendent of Skype's PgQ, for running queue-like workloads in Postgres.

🎧 https://t.co/mT6M00PNHJ

📺 https://t.co/flYAKnqMcF

[Postgres FM @PostgresFM]

New episode: "pg_wait_tracer"

Nik and Michael are joined by Dmitry Fomin to discuss his new tool pg_wait_tracer, as well as changes to core that would allow wait event tracing with lower overhead (and on managed services).

🎧 https://t.co/oEgydSWt1X

📺 https://t.co/hN7nd5zIjh

[Postgres FM @PostgresFM]

New episode: "Schema design checklist"

Nik and Michael discuss a list of things to check when designing new schema in Postgres.

🎧 https://t.co/PxKtoUDRbN

📺 https://t.co/Zl5596TzAv

[Postgres FM @PostgresFM]

New episode: "What's missing in Postgres?"

Nik and Michael are joined by Bruce Momjian to discuss his new talk.

🎧 https://t.co/7UHJvqChJ1

📺 https://t.co/OzVm5Aatw8

[Postgres FM @PostgresFM]

New episode: "Long-running transactions"

Nik and Michael discuss long-running transactions, including when they're harmless, when they cause issues, and how to mitigate those issues.

🎧 https://t.co/knAwhJutyi

📺 https://t.co/PcwUryJsTa

[Postgres FM @PostgresFM]

New episode: "PostGIS"

@samokhvalov and @michristofides are joined by @reginaobe and @pwramsey to discuss @PostGIS

🎧 https://t.co/XqcDKMOdFE

📺 https://t.co/5sUw7di3KE

[Postgres FM @PostgresFM]

New episode: "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.

🎧 https://t.co/u69Zk9BaYQ

📺 https://t.co/jrtK4fg1lR

[Postgres FM @PostgresFM]

New episode: "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.

🎧 https://t.co/H2CE1H0J3v

📺 https://t.co/UECK5rHp77