Postgres FM

A weekly podcast about all things PostgreSQL

142 episodes transcribed
0 comments
Technology

Denormalization

Episode Date: November 8, 2024

Nikolay and Michael discuss denormalization in Postgres — when and why to denormalize things, and a couple of specific cases Nikolay came acr...

0 comments
Technology

Advanced psql

Episode Date: October 25, 2024

Nikolay and Michael discuss some cool things you can do with psql, the official CLI that ships with Postgres. Here are some links to things t...

0 comments
Technology

Postgres Gotchas

Episode Date: October 18, 2024

Nikolay and Michael discuss some Postgres Gotchas, things you might expect to work one way in fact working another way. Here are some links t...

0 comments
Technology

Advanced EXPLAIN

Episode Date: October 11, 2024

Nikolay and Michael discuss some more advanced topics around EXPLAIN, including some tips for complex query plans, some recent improvements,...

0 comments
Technology

Patroni

Episode Date: October 4, 2024

Michael and Nikolay are joined by Alexander Kukushkin, PostgreSQL contributor and maintainer of Patroni, to discuss all things Patroni — what...

0 comments
Technology

Postgres 17

Episode Date: September 27, 2024

Nikolay and Michael discuss the fresh new Postgres 17 release! They cover several performance improvements, favourite new features, and some...

0 comments
Technology

Planning time

Episode Date: September 20, 2024

Nikolay and Michael discuss planning time in Postgres — what it is, how to spot issues, its relationship to things like partitioning, and som...

0 comments
Technology

Slow count

Episode Date: September 13, 2024

Nikolay and Michael discuss why counting can be slow in Postgres, and what the options are for counting things quickly at scale. Here are som...

0 comments
Technology

Skip scan

Episode Date: September 6, 2024

Michael and Nikolay are joined by Peter Geoghegan, major contributor and committer to Postgres, to discuss adding skip scan support to Postgr...

0 comments
Technology

Postgres Emergency Room

Episode Date: August 30, 2024

Nikolay and Michael discuss PostgreSQL emergencies — both the psychological side of incident management, and some technical aspects too. Here...

0 comments
Technology

Get or Create

Episode Date: August 23, 2024

Michael and Nikolay are joined by Haki Benita, a technical lead and database enthusiast who writes an excellent blog and gives popular talks...

0 comments
Technology

Index-Only Scans

Episode Date: August 9, 2024

Nikolay and Michael discuss Index-Only Scans in Postgres — what they are, how they help, some things to look out for, and some advice. Here a...

0 comments
Technology

Why Postgres?

Episode Date: August 2, 2024

Nikolay and Michael discuss why they chose Postgres — as users, for their businesses, for their careers, as well as some doubts. Here are som...

0 comments
Technology

Compression

Episode Date: July 26, 2024

Nikolay and Michael discuss compression in Postgres — what's available natively, newer algorithms in recent versions, and several extensions...

0 comments
Technology

Out of disk

Episode Date: July 19, 2024

Nikolay and Michael discuss Postgres running out of disk space — including what happens, what can cause it, how to recover, and most importan...

0 comments
Technology

Four million TPS

Episode Date: July 5, 2024

Nikolay talks Michael through a recent experiment to find the current maximum transactions per second single-node Postgres can achieve — why...

0 comments
Technology

Soft delete

Episode Date: June 28, 2024

Nikolay and Michael discuss soft deletion in Postgres — what it means, several use cases, some implementation options, and which implementati...