A weekly podcast about all things PostgreSQL
178 episodes transcribedNik 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 wai...
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 BIG...
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 mentione...
Nik and Michael discuss long-running transactions, including when they're harmless, when they cause issues, and how to mitigate those issues....
Nik and Michael are joined by Regina Obe and Paul Ramsey to discuss PostGIS. Here are some links to things they mentioned:Regina Obe https://...
Nik and Michael discuss query plan flips in Postgres — what they are, some causes, mitigations, longer term solutions, and the recent outage...
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 som...
Nik and Michael discuss query level comments, object level comments, and another way of adding object level metadata. Here are some links to...
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:/...
Nik and Michael are joined by Radim Marek from boringSQL to talk about RegreSQL, a regression testing tool for SQL queries they forked and im...
Nik and Michael discuss the events and trends they thought were most important in the Postgres ecosystem in 2025. Here are some links to thin...
Nik and Michael discuss a listener question about archiving a database. Here are some links to things they mentioned: Listener request to tal...
Nik and Michael discuss max_connections, especially in the context of increasing it to solve problems like migrations intermittently failing(...
Nik and Michael discuss the various changes to EXPLAIN that arrived in Postgres 18. Here are some links to things they mentioned: EXPLAIN (of...
Nik talks Michael through a recent benchmark he worked with Maxim Boguk on, to see how quickly they could provision a replica. Here are some...
Nik and Michael discuss the concept of gapless sequences — when you might want one, why sequences in Postgres can have gaps, and an idea or t...
Nik and Michael discuss lightweight locks in Postgres — how they differ to (heavier) locks, some occasions they can be troublesome, and some...
Nik and Michael discuss user management in Postgres — how roles work, making administration easier, setting passwords, and avoiding them bein...
Nik and Michael discuss the newly released Postgres 18 — the bigger things it includes, some of their personal highlights, and some thoughts...
Nik and Michael are joined by Harry Brundage from Gadget to talk about their recent zero-downtime major version upgrade, how they use Postgre...
