Postgres FM

A weekly podcast about all things PostgreSQL

143 episodes transcribed
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...

0 comments
Technology

pgvectorscale

Episode Date: June 14, 2024

Nikolay is joined by Mat Arye and John Pruitt, from Timescale, to discuss their new extension pgvectorscale and high-performance vector searc...

0 comments
Technology

Full text search

Episode Date: May 24, 2024

Nikolay and Michael discuss full text search in Postgres — some of the history, some of the features, and whether it now makes sense to try t...

0 comments
Technology

Minor releases

Episode Date: May 17, 2024

Nikolay and Michael discuss Postgres minor releases — how the schedule works, options for upgrading to them, and the importance of reading th...

0 comments
Technology

Custom vs generic plan

Episode Date: May 10, 2024

Nikolay and Michael discuss custom and generic planning in prepared statements — how it works, how issues can present themselves, some ways t...

0 comments
Technology

LIMIT vs Performance

Episode Date: May 3, 2024

Nikolay and Michael discuss LIMIT in Postgres — what it does, how it can help with performance, and an interesting example where adding it ca...

0 comments
Technology

Massive DELETEs

Episode Date: April 19, 2024

Nikolay and Michael discuss doing massive DELETE operations in Postgres — what can go wrong, how to prevent major issues, and some ideas to m...

0 comments
Technology

Don't do this

Episode Date: April 5, 2024

Nikolay and Michael discuss several "Don't do this" lists about Postgres — picking out their favourite items, as well as some contentious one...

0 comments
Technology

Search

Episode Date: March 29, 2024

Nikolay and Michael have a high-level discussion on all things search — touching on full-text search, semantic search, and faceted search. Th...

0 comments
Technology

Health check

Episode Date: March 22, 2024

Nikolay and Michael discuss Postgres health checks — what they are, things to include, how often makes sense, and whether improvements to Pos...

0 comments
Technology

superuser

Episode Date: March 15, 2024

Nikolay and Michael discuss the superuser role in PostgreSQL — what it is, how and when it shouldn’t be used, and whether most cloud provider...

0 comments
Technology

transaction_timeout

Episode Date: March 8, 2024

Nikolay and Michael discuss transaction_timeout (a recently committed addition for Postgres 17) — what it's for, how to get around not having...

0 comments
Technology

Rails + Postgres

Episode Date: March 1, 2024

Michael and Nikolay are joined by Andrew Atkinson, author of High Performance PostgreSQL for Rails, to discuss how Rails and Postgres work to...