Podcast Episodes
Back to Searchpg_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 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 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, 1 month ago
Column Tetris
Episode 126
Nikolay and Michael discuss "Column Tetris" — what it is, why it matters, how to order columns for new tables, and how to re-organise existing ones.
…
1 year, 1 month ago
pg_stat_statements track_planning
Episode 125
Nikolay and Michael discuss the track_planning parameter of pg_stat_statements — what it is, how it affects performance, and when or whether you shou…
1 year, 1 month ago
Is pg_dump a backup tool?
Episode 124
Michael and Nikolay are joined by Gülçin Yıldırım Jelínek and Robert Haas to discuss both the technical question of whether or not pg_dump is a backu…
1 year, 1 month ago
Append-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, 2 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, 2 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, 2 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, 2 months ago