Podcast Episodes

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, 3 months ago

View Episode

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, 4 months ago

View Episode

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, 4 months ago

View Episode

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, 4 months ago

View Episode

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, 4 months ago

View Episode

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, 5 months ago

View Episode

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, 5 months ago

View Episode

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…

1 year, 5 months ago

View Episode

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…

1 year, 5 months ago

View Episode

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, …

1 year, 5 months ago

View Episode