Postgres FM

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 https://www.timbira.com.br
PlanetScale https://planetscale.com
pg_stat_log https://github.com/fabriziomello/pg_stat_log
Custom Cumulative Statistics (docs) https://www.postgresql.org/docs/current/xfunc-c.html#XFUNC-ADDIN-CUSTOM-CUMULATIVE-STATISTICS
Custom Cumulative Statistics (wiki page) https://wiki.postgresql.org/wiki/CustomCumulativeStats
logerrors https://github.com/munakoiso/logerrors
pgFouine https://www.postgresql.org/ftp/projects/pgFoundry/pgfouine/pgFouine
pgBadger https://github.com/darold/pgbadger
pg_stat_checkpointer https://www.postgresql.org/docs/current/monitoring-stats.html#MONITORING-PG-STAT-CHECKPOINTER-VIEW
pg_wait_sampling https://github.com/postgrespro/pg_wait_sampling
RFC: pg_stat_logmsg (patch proposal by Joe Conway) https://www.postgresql.org/message-id/flat/89742024-d51a-c66b-90b9-67f837072cd2%40joeconway.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

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
pg_basebackup https://www.postgresql.org/docs/current/app-pgbasebackup.html
Barman https://pgbarman.org
pgmoneta https://github.com/pgmoneta/pgmoneta
WAL-G https://github.com/wal-g/wal-g
Return pg_control from pg_backup_stop (patch proposal) https://www.postgresql.org/message-id/flat/86436ff9-eb98-4c8a-825e-3bcae022107b%40pgbackrest.org#e36e2ad2f410d1a9a1152e36aa66bb48
Add StorageReadMulti for prefetched multi-file/range reads from object stores (pgBackRest change that needs review) https://github.com/pgbackrest/pgbackrest/pull/2783
pg_hardstorage https://github.com/cybertec-postgresql/pg_hardstorage
Why the cycle of open-source sustainability needs to be virtuous (blog post by Gabriele Bartolini) https://www.gabrielebartolini.it/articles/2026/04/why-the-cycle-of-open-source-sustainability-needs-to-be-virtuous
ARIN https://www.arin.net
Stefan Fercot https://pgstef.github.io/about
pgBackRest sponsors at the time of recording: AWS, Supabase, pgEdge, Tiger Data, Percona, Eon, Xata, Dalibo, Data Egret

~~~
00:00 – Intro & pgBackRest origin story
03:07 – Could pgBackRest live in Postgres core? Why it hasn't happened
11:37 – Primary vs. standby backups & corruption safety
20:36 – Measuring RPO & RTO in practice
26:20 – Checksum performance & S3 storage class tips
30:02 – Standby replay bottleneck
35:12 – Log shipping, streaming replication, and sharding
44:56 – Maintenance reality & the sponsorship crisis
47:41 – What's next: repo-to-repo backup & RPO-zero streaming
56:00 – Incremental backup
1:05:01 – Reliability philosophy
1:10:05 – Second maintainer, community growth & wrap-up
~~~
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

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 https://www.postgresql.org/docs/current/routine-vacuuming.html#AUTOVACUUM
autovacuum configuration parameters https://www.postgresql.org/docs/current/runtime-config-vacuum.html#RUNTIME-CONFIG-AUTOVACUUM
What’s Missing in Postgres? (our episode with Bruce Momjian) https://postgres.fm/episodes/what-s-missing-in-postgres
pg_squeeze (our episode with Antonín Houska) https://postgres.fm/episodes/pg_squeeze
My queries to monitor autovacuum (post by Laurenz Albe) https://www.cybertec-postgresql.com/en/monitor-autovacuum-my-queries/
Autovacuum Tuning Basics (post by Tomas Vondra, originally for 2nd Quadrant blog) https://www.enterprisedb.com/blog/autovacuum-tuning-basics
Zero autovacuum_vacuum_cost_delay, Write Storms, and You (post by Jeremy Schneider) https://ardentperf.com/2026/04/12/zero-autovacuum_cost_delay-write-storms-and-you/
Our episode on long-running transactions / xmin horizon https://postgres.fm/episodes/long-running-transactions

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

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 https://postgres.fm/people/david-ventimiglia
pg_flight_recorder https://github.com/dventimisupabase/pg_flight_recorder
Supabase https://supabase.com
pg_wait_sampling https://github.com/postgrespro/pg_wait_sampling
pg_ash https://github.com/NikolayS/pg_ash
pg_cron https://github.com/citusdata/pg_cron
pg_tle https://github.com/aws/pg_tle

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

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 https://postgres.fm/episodes/queues-in-postgres
PgQue https://github.com/NikolayS/pgque
HN discussion https://news.ycombinator.com/item?id=47817349
PgQ https://github.com/pgq/pgq
pgmq https://github.com/pgmq/pgmq
River https://riverqueue.com
Keeping a Postgres queue healthy (blog post by Simeon Griggs / PlanetScale) https://planetscale.com/blog/keeping-a-postgres-queue-healthy
Postgres Job Queues & Failure By MVCC (blog post by Brandur) https://brandur.org/postgres-queues
My queries to monitor autovacuum (blog post by Laurenz Albe) https://www.cybertec-postgresql.com/en/monitor-autovacuum-my-queries/
SELECT FOR UPDATE considered harmful (blog post by Laurenz Albe) https://www.cybertec-postgresql.com/en/select-for-update-considered-harmful-postgresql/
Christophe Pettus blog post https://thebuild.com/blog/2026/05/03/pgque-two-snapshots-and-a-diff
Our episode on pg_ash https://postgres.fm/episodes/pg_ash
Rediscovering PgQ (Alexander Kukushkin slides) https://speakerdeck.com/cyberdemn/rediscovering-pgq
Tick frequency tuning https://github.com/NikolayS/PgQue/blob/main/docs/tick-frequency.md

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