Soft delete
Episode Date: June 28, 2024Nikolay and Michael discuss soft deletion in Postgres — what it means, several use cases, some implementation options, and which implementati...
A weekly podcast about all things PostgreSQL
143 episodes transcribedNikolay and Michael discuss soft deletion in Postgres — what it means, several use cases, some implementation options, and which implementati...
Nikolay and Michael discuss foreign keys in Postgres — what they are, their benefits, their overhead, some edge cases to be aware of, some im...
Nikolay is joined by Mat Arye and John Pruitt, from Timescale, to discuss their new extension pgvectorscale and high-performance vector searc...
Michael and Nikolay are joined by three special guests for episode 100 who have all scaled Postgres to significant scale — Arka Ganguli from...
Michael is joined by Claire Giordano, Head of Postgres Open Source Community Initiatives at Microsoft, to discuss several ways to contribute...
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...
Nikolay and Michael discuss Postgres minor releases — how the schedule works, options for upgrading to them, and the importance of reading th...
Nikolay and Michael discuss custom and generic planning in prepared statements — how it works, how issues can present themselves, some ways t...
Nikolay and Michael discuss LIMIT in Postgres — what it does, how it can help with performance, and an interesting example where adding it ca...
Nikolay and Michael return to the topic of using the buffers explain parameter — with a new analogy, some (conspiracy) theories of why it's s...
Nikolay and Michael discuss doing massive DELETE operations in Postgres — what can go wrong, how to prevent major issues, and some ideas to m...
Nikolay and Michael are joined by Sai Srirampur, CEO and Co-founder of PeerDB, to discuss how to overcome several logical replication issues....
Nikolay and Michael discuss several "Don't do this" lists about Postgres — picking out their favourite items, as well as some contentious one...
Nikolay and Michael have a high-level discussion on all things search — touching on full-text search, semantic search, and faceted search. Th...
Nikolay and Michael discuss Postgres health checks — what they are, things to include, how often makes sense, and whether improvements to Pos...
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...
Nikolay and Michael discuss transaction_timeout (a recently committed addition for Postgres 17) — what it's for, how to get around not having...
Michael and Nikolay are joined by Andrew Atkinson, author of High Performance PostgreSQL for Rails, to discuss how Rails and Postgres work to...
Nikolay and Michael discuss a common question — why Postgres isn't using an index, and what you can do about it! Here are some links to thing...
Nikolay and Michael discuss the overhead of pg_stat_statements and pg_stat_kcache — mostly focusing on some interesting things Nikolay found...