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
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
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
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
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
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
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
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
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
New episode: "Comments and metadata"
Nik and Michael discuss query level comments, object level comments, and another way of adding object level metadata.
๐ง https://t.co/Sgr5r40EJv
๐บ https://t.co/8g5FHymbt5
New episode: "PgDog update"
@samokhvalov and @michristofides are joined by Lev Kokotov for an update on all things PgDog.
๐ง https://t.co/vfEstIK9m9
๐บ https://t.co/M2meDSg9JQ
New episode: "RegreSQL"
Nik and Michael are joined by Radim Marek from boringSQL to talk about RegreSQL, a regression testing tool for SQL queries (forked and improved).
๐ง https://t.co/OgD1xSfNqL
๐บ https://t.co/Iio4VoRFK2
New episode: "Postgres year in review 2025"
Nik and Michael discuss the events and trends they thought were most important in the Postgres ecosystem in 2025.
๐ง https://t.co/mxUXoZgyQs
๐บ https://t.co/VLormJqDjc
New episode: "Archiving"
Nik and Michael discuss a listener question about archiving a database.
๐ง https://t.co/akLzNO5HAI
๐บ https://t.co/ZmgyUv2unP
New episode: "max_connections vs migrations"
Nik and Michael discuss max_connections, especially in the context of increasing it to solve problems like migrations intermittently failing(!)
๐ง https://t.co/3sN6YY1b9J
๐บ https://t.co/8LOhzd7YyO
New episode: "What's new in EXPLAIN"
Nik and Michael discuss the various changes to EXPLAIN that arrived in Postgres 18.
๐ง https://t.co/bNpmOUChDZ
๐ท https://t.co/QT1I1YW2Zd
New episode: "Tens of TB per hour"
Nik talks Michael through a recent benchmark he worked with Maxim Boguk on, to see how quickly they could provision a replica.
๐ง https://t.co/NTbL4wMCJn
๐บ https://t.co/nMIOwkcUDL
New episode: "Gapless sequences"
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 two if you do want them.
๐ง https://t.co/a3vxL6YWNU
๐บ https://t.co/XVGyrnjQTI
New episode: "LWLocks"
Nik and Michael discuss lightweight locks in Postgres โ how they differ to (heavier) locks, some occasions they can be troublesome, and some resources for working out what to do if you hit issues.
๐ง https://t.co/AqEXZWKyER
๐บ https://t.co/hverE778te