Podcast Episodes
Back to Searchauto_explain
Episode 43
Nikolay and Michael discuss auto_explain — what it is, how it can help, and how to check it's overhead.
Here are links to a few things we mentioned: …
3 years, 5 months ago
Queues in Postgres
Episode 42
Nikolay and Michael discuss queues in Postgres — the pros and cons vs dedicated queuing tools, and some tips for scaling.
A couple of apologies-in-ad…
3 years, 6 months ago
Read-only considerations
Episode 41
Nikolay and Michael discuss a listener request — special considerations for databases that are used in a read-only mode all day, and get an update at…
3 years, 6 months ago
Partitioning
Episode 40
Nikolay and Michael discuss table partitioning — what it is, why and when it's helpful, and some considerations for your partition key.
Here are link…
3 years, 6 months ago
Peter Zaitsev
Episode 39
This week we're sharing an edited version of Nikolay's recent interview with Peter Zaitsev from Percona — they discuss MySQL vs Postgres, Percona’s s…
3 years, 6 months ago
psql vs GUIs
Episode 38
Nikolay and Michael discuss command line and graphical user interfaces for Postgres — what they are, some tips and tricks for learning, and what we e…
3 years, 7 months ago
Upgrades
Episode 37
Nikolay and Michael discuss major and minor version Postgres upgrades — what they are, how often they come out, and how regularly we should be upgrad…
3 years, 7 months ago
Wait events
Episode 36
Nikolay and Michael discuss wait events — what they are, why we have them, and how to use them to help diagnose performance issues.
Here are links to…
3 years, 7 months ago
TOAST
Episode 35
Nikolay and Michael discuss TOAST (The Oversized-Attribute Storage Technique) — what it is, how it works, and some general things to be aware of.
Her…
3 years, 7 months ago
JSON
Episode 34
Nikolay and Michael discuss JSON — our options for storing it in Postgres, whether or when we should, as well as a brief intro and some tips for JSON…
3 years, 8 months ago