Podcast Episodes
Back to SearchPeter 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…
2 years, 9 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…
2 years, 9 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…
2 years, 9 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…
2 years, 10 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…
2 years, 10 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…
2 years, 10 months ago
Real-time analytics
Episode 33
Nikolay and Michael discuss real-time analytics — what it means, what the options are, and some tips if you're trying to implement it within Postgres…
2 years, 10 months ago
Benchmarking
Episode 32
Nikolay and Michael discuss benchmarking — reasons to do it, and some approaches, tools, and resources that can help.
Here are links to a few things …
2 years, 11 months ago
Default configuration
Episode 31
Nikolay and Michael discuss the default config — some tools and principles you can use to customise it, as well as several parameters you probably al…
2 years, 11 months ago
Infra cost optimization
Episode 30
Here are links to a few things we mentioned:
The Cost of Cloud, a Trillion Dollar Paradox (blog post from Andreessen Horowitz)OVHHetznerpostgresql_cl…2 years, 11 months ago