Podcast Episodes
Back to SearchAppend-only tables
Episode 123
Nikolay and Michael discuss append-only tables in Postgres — what they are, some unique challenges they bring, and some options for compressing / rem…
1 year, 11 months ago
Denormalization
Episode 122
Nikolay and Michael discuss denormalization in Postgres — when and why to denormalize things, and a couple of specific cases Nikolay came across rece…
1 year, 11 months ago
Postgres online communities
Episode 121
Nikolay and Michael discuss online Postgres communities — the ones they prefer, the types of conversations in each, and some other places to ask ques…
1 year, 11 months ago
Advanced psql
Episode 120
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 they ment…
1 year, 11 months ago
Postgres Gotchas
Episode 119
Nikolay and Michael discuss some Postgres Gotchas, things you might expect to work one way in fact working another way.
Here are some links to things…
2 years ago
Advanced EXPLAIN
Episode 118
Nikolay and Michael discuss some more advanced topics around EXPLAIN, including some tips for complex query plans, some recent improvements, and an i…
2 years ago
Patroni
Episode 117
Michael and Nikolay are joined by Alexander Kukushkin, PostgreSQL contributor and maintainer of Patroni, to discuss all things Patroni — what it is, …
2 years ago
Postgres 17
Episode 116
Nikolay and Michael discuss the fresh new Postgres 17 release! They cover several performance improvements, favourite new features, and some consider…
2 years ago
Planning time
Episode 115
Nikolay and Michael discuss planning time in Postgres — what it is, how to spot issues, its relationship to things like partitioning, and some tips f…
2 years, 1 month ago
Slow count
Episode 114
Nikolay and Michael discuss why counting can be slow in Postgres, and what the options are for counting things quickly at scale.
Here are some links …
2 years, 1 month ago