Podcast Episodes

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

View Episode

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

View Episode

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

View Episode

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

View Episode

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

View Episode

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

View Episode

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

View Episode

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, 10 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, 10 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, 11 months ago

View Episode