Postgres FM

A weekly podcast about all things PostgreSQL

149 episodes transcribed
0 comments
Technology

pg_duckdb

Episode Date: January 3, 2025

Michael and Nikolay are joined by Joe Sciarrino and Jelte Fennema-Nio to discuss pg_duckdb — what it is, how it started, what early users are...

0 comments
Technology

RLS vs performance

Episode Date: December 20, 2024

Nikolay and Michael discuss Row Level Security in Postgres, focussing on the performance side effects and some tips to avoid (or minimize) th...

0 comments
Technology

jOOQ

Episode Date: December 13, 2024

Michael and Nikolay are joined by Lukas Eder, the creator of jOOQ, to discuss what it is, some nice developer experience features it has, and...

0 comments
Technology

Column Tetris

Episode Date: December 6, 2024

Nikolay and Michael discuss "Column Tetris" — what it is, why it matters, how to order columns for new tables, and how to re-organise existin...

0 comments
Technology

Append-only tables

Episode Date: November 15, 2024

Nikolay and Michael discuss append-only tables in Postgres — what they are, some unique challenges they bring, and some options for compressi...

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