Podcast Episodes
Back to SearchPgDog
Episode 139
Nikolay and Michael are joined by Lev Kokotov to discuss PgDog — including whether or when sharding is needed, the origin story (via PgCat), what's already supported, and what's coming next.
Here …
Published on 5 months, 3 weeks ago
Snapshots
Episode 138
Nikolay talks Michael through using cloud snapshots — how they can be used to reduce RTO for huge Postgres setups, also to improve provisioning time, and some major catches to be aware of.
Here are s…
Published on 5 months, 4 weeks ago
GIN Indexes
Episode 137
Nikolay and Michael discuss GIN indexes in Postgres — what they are, what they're used for, and some limitations to be aware of.
Here are some links to things they mentioned:
Published on 6 months ago
Best 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, performance, backups, and more.
Here are some links to thin…
Published on 6 months, 1 week 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.
Here are some links to things they mentioned:
Published on 6 months, 3 weeks 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 denormalisation, developer experience, NULLs, and more!
Here are…
Published on 7 months 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 ANALYZE in Postgres 18, and what effect that might h…
Published on 7 months, 1 week 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 links to things they mentioned:
Published on 7 months, 3 weeks 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 mentioned:
Published on 8 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 functionality into core.
Here are some links to thi…
Published on 8 months, 1 week ago