Podcast Episodes
Back to SearchTop ten dangerous issues
Episode 144
Nikolay and Michael discuss ten dangerous Postgres related issues — ones that might be painful enough to get onto the CTO and even CEOs desk, and then what you can do proactively.
The ten issues disc…
Published on 6 months ago
synchronous_commit
Episode 143
Nikolay and Michael discuss synchronous_commit — what it means on single node setups, for synchronous replication setups, and the pros and cons of the different options for each.
Here are some links …
Published on 6 months, 1 week ago
Managed service support
Episode 142
Nikolay and Michael discuss managed service support — some tips on how to handle cases that aren't going well, tips for requesting features, whether to factor in support when choosing service provide…
Published on 6 months, 2 weeks ago
Time-series considerations
Episode 141
Nikolay and Michael discuss time-series considerations for Postgres — including when it matters, some tips for avoiding issues, performance considerations, and more.
Here are some links to things the…
Published on 7 months ago
Performance cliffs
Episode 140
Nikolay and Michael are joined by Tomas Vondra to discuss single query performance cliffs — what they are, why they happen, some things we can do to make them less likely or less severe, and some pot…
Published on 7 months, 1 week ago
PgDog
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 7 months, 2 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 7 months, 3 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 8 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 8 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 8 months, 2 weeks ago