Postgres FM

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

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 links to things they mentioned: 
Dmitry Fomin https://postgres.fm/people/dmitry-fomin
pg_wait_tracer https://github.com/DmitryNFomin/pg_wait_tracer
pg_wait_sampling https://github.com/postgrespro/pg_wait_sampling
pg_10046 https://github.com/DmitryNFomin/pg_10046
Jeremy Schneider reply on LinkedIn https://www.linkedin.com/feed/update/urn:li:activity:7414966981847748608
RDS for PostgreSQL wait event docs https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/PostgreSQL.Tuning.concepts.summary.html
Custom wait events for extensions (added in PostgreSQL 17) https://www.postgresql.org/docs/current/xfunc-c.html#XFUNC-ADDIN-WAIT-EVENTS
Hacking Postgres with Dmitry, Kirk, and Nik (Part 1) https://www.youtube.com/watch?v=3Gtuc2lnnsE
Hacking Postgres with Dmitry, Kirk, and Nik (Part 2) https://www.youtube.com/watch?v=6kqpjnpl5Gc
Tanel Poder https://tanelpoder.com/about/
USDT static tracepoints for wait event tracing (proof of concept by Nik) https://github.com/NikolayS/postgres/pull/18
Add wait_event_timing: Oracle-style wait event instrumentation (patch by Dmitry) https://github.com/DmitryNFomin/postgres/pull/1
PgQue benchmarks https://github.com/NikolayS/pgque/blob/main/docs/benchmarks.md
The Art of Computer Systems Performance Analysis Techniques for Experimental Design, Measurement, Simulation and Modeling (by Raj K. Jain) https://www.researchgate.net/publication/259310412_The_Art_of_Computer_Systems_Performance_Analysis_Techniques_For_Experimental_Design_Measurement_Simulation_and_Modeling_NY_Wiley
Performance modeling and design of computer systems queueing theory in action (by Prof. Mor Harchol-Balter) https://www.cs.cmu.edu/~harchol/PerformanceModeling/book.html
Oracle Performance Firefighting (by Craig_Shallahamer) https://www.abebooks.co.uk/9780984102303/Oracle-Performance-Firefighting-Craig-Shallahamer-0984102302/plp
Process Mining: Data Science in Action (by Wil van der Aalst) https://link.springer.com/book/10.1007/978-3-662-49851-4

~~~
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 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) https://blog.rustprooflabs.com/2021/06/postgres-bigint-by-default
Postgres 18 and UUIDv7 (blog post by Gwen Shapira) https://www.thenile.dev/blog/uuidv7
How to use UUID (how-to guide by Nik) https://postgres.ai/docs/postgres-howtos/schema-design/data-types/how-to-use-uuid
Our episode on constraints https://postgres.fm/episodes/constraints
Our episode on NULLs https://postgres.fm/episodes/nulls-the-good-the-bad-the-ugly-and-the-unknown
MultiXact member space exhaustion episode (with Metronome) https://postgres.fm/episodes/multixact-member-space-exhaustion
Our Column Tetris episode https://postgres.fm/episodes/column-tetris
Saving Space Basically for Free (blog post by James Coleman from Braintree) https://medium.com/paypal-tech/postgresql-at-scale-saving-space-basically-for-free-d94483d9ed9a
Over-indexing episode https://postgres.fm/episodes/over-indexing
Under-indexing episode https://postgres.fm/episodes/under-indexing
Gadget's use of Postgres https://postgres.fm/episodes/gadgets-use-of-postgres
Partitioning episode https://postgres.fm/episodes/partitioning
RLS vs performance episode https://postgres.fm/episodes/rls-vs-performance

~~~
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 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 https://www.enterprisedb.com
What’s Missing in Postgres? (Bruce’s slides) https://momjian.us/main/writings/pgsql/missing.pdf
The Wonderful World of WAL (Bruce’s slides) https://momjian.us/main/writings/pgsql/wal.pdf
Getting started with benchmarking (our episode with Melanie Plageman) https://postgres.fm/episodes/getting-started-with-benchmarking
Myths and Truths about Synchronous Replication in Postgres (talk by Alexander Kukushkin) https://www.youtube.com/watch?v=PFn9qRGzTMc
The Future of Postgres Sharding (Bruce’s slides) https://momjian.us/main/writings/pgsql/sharding.pdf
MultiXact member space exhaustion https://postgres.fm/episodes/multixact-member-space-exhaustion

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