Podcast Episodes
Back to SearchBest Practices
Episode 136
Nikolay and Michael use a recent "best practices" article as a prompt — giving a few tips each on the topics mentioned, like schema design, performan…
1 year ago
Extended Statistics
Episode 135
Nikolay and Michael discuss the CREATE STATISTICS feature in Postgres — what it's for, how often it's used, and how to spot cases where it would help…
1 year, 1 month ago
SQL vs NoSQL
Episode 134
Nikolay and Michael are joined by Franck Pachot to discuss SQL vs NoSQL — did Franck change teams by joining MongoDB, normalisation vs denormalisatio…
1 year, 1 month ago
Return of the BUFFERS
Episode 133
Nikolay and Michael return to the topic of BUFFERS for the third (and final?) time! They discuss the news that it'll be on by default with EXPLAIN AN…
1 year, 1 month ago
Reads causing writes
Episode 132
Nikolay and Michael discuss a couple of surprising ways read queries (selects) can cause writes (shared buffers dirtied) in Postgres.
Here are some l…
1 year, 2 months ago
NOT VALID constraints
Episode 131
Nikolay and Michael discuss adding constraints in an online fashion, using NOT VALID and then VALIDATE CONSTRAINT.
Here are some links to things they…
1 year, 2 months ago
pg_squeeze
Episode 130
Michael and Nikolay are joined by Antonín Houska to discuss pg_squeeze — what it is, how it started, some of its features, and hopes of getting the f…
1 year, 2 months ago
pg_duckdb
Episode 129
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 using i…
1 year, 3 months ago
RLS vs performance
Episode 128
Nikolay and Michael discuss Row Level Security in Postgres, focussing on the performance side effects and some tips to avoid (or minimize) them.
Here…
1 year, 3 months ago
jOOQ
Episode 127
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 some fu…
1 year, 3 months ago