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

🎧 Podcast + 📺 YouTube
New episode: "GSoC B-Tree Merge" Nik and Michael are joined by Salma El-Sayed and Kirk Wolak to discuss their ambitious Google Summer of Code project around adding b-tree merge support to Postgres. 🎧️️ postgres.fm/episodes/gsoc-bt… 📺️️ piped.video/vspGoD9Dc7k
3
6
552
New episode: "ClickHouse Managed Postgres" Nik and Michael are joined by @saisrirampur to discuss @ClickHouseDB's new managed Postgres service. 🎧️ postgres.fm/episodes/clickho… 📺️ piped.video/jRCjB_Vy7cE
1
10
24
3,353
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. 🎧 postgres.fm/episodes/hot_sta… 📺 piped.video/B0v3DAe-B7A
3
3,031
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. 🎧 postgres.fm/episodes/estimat… 📷 piped.video/cFRQsOdGdOU
1
9
499
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. 🎧 postgres.fm/episodes/pgrust 📺 piped.video/cvNlTQWZYG4
3
10
2,062
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. 🎧️️️ postgres.fm/episodes/mvcc 📺️️️ piped.video/MHiiI0GZS3A
2
14
1,764
New episode: "Xata" Nik and Michael are joined by @tudor_g, CTO of @xata, to discuss their architecture, progress, and open source tooling. 🎧️️ postgres.fm/episodes/xata 📺️️ piped.video/hNUw1349yes
4
13
1,541
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. 🎧️ postgres.fm/episodes/dbos 📺️ piped.video/TuIBzuOcN0Y
9
23
3,739
New episode: "pg_stat_log" Nik and Michael are joined by @fabriziomello to discuss his new extension pg_stat_log. 🎧 postgres.fm/episodes/pg_stat… 📺 piped.video/xr5kv1WUdWM
1
6
12
4,023
New episode: "pgBackRest" Nik and Michael are joined by David Steele to talk all things pgBackRest. 🎧 postgres.fm/episodes/pgbackr… 📺 piped.video/6SsFa-sQiH8
1
4
10
2,897
Due to travelling and holidays we’re taking a few weeks off, but we’re excited to be back after that!
1
7
672
New episode: "autovacuum" Nik and Michael discuss autovacuum, including what it does, and the basics of why and how to tune it. 🎧 postgres.fm/episodes/autovac… 📺 piped.video/WMNjHTgYH_c
7
389
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. 🎧 postgres.fm/episodes/pg_flig… 📺 piped.video/UirSQIY8_M0
3
13
1,943
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. 🎧 postgres.fm/episodes/pgque 📺 piped.video/bBNcR14Ts4U
1
2
9
2,005
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). 🎧 postgres.fm/episodes/pg_wait… 📺 piped.video/efY85jwfcQ8
2
7
2,791
New episode: "Schema design checklist" Nik and Michael discuss a list of things to check when designing new schema in Postgres. 🎧 postgres.fm/episodes/schema-… 📺 piped.video/Z3AboE-kFZU
14
6,152
New episode: "What's missing in Postgres?" Nik and Michael are joined by Bruce Momjian to discuss his new talk. 🎧 postgres.fm/episodes/what-s-… 📺 piped.video/F3FMvni6j2U
1
4
11
4,093
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. 🎧 postgres.fm/episodes/long-ru… 📺 piped.video/uSUpbUJM5Kk
5
37
1,928
New episode: "PostGIS" @samokhvalov and @michristofides are joined by @reginaobe and @pwramsey to discuss @PostGIS 🎧 postgres.fm/episodes/postgis 📺 piped.video/JDULwjz1hDY
1
4
13
1,478
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. 🎧 postgres.fm/episodes/plan-fl… 📺 piped.video/sjv_D18QwTs
2
5
1,728