PostgreSQL Performance Theory Made Practical
Baron is the founder and CEO of VividCortex, the best way to see what your production database servers are doing. Baron has written a lot of open source software, and several books. He’s focused his career on learning and teaching about performance and observability of systems generally (including the view that teams are systems and culture influences their performance), and databases specifically.
No video of the event yet, sorry!
Like most people, I've Googled for advice and recommended best practices for PostgreSQL performance, but I always wondered: are we there yet? How do I know if my performance is optimized? What if I could still get better performance?
Then one day I discovered Cary Millsap, the light-bulb turned on, and I found the answers. (For Oracle, but it started me on the path that led me to today.) It turns out you can (and should) answer this question easily. In fact, you are better off finding the answer before you start optimizing, not just as a check to see if you've done all you could.
In this talk I'll show you what I've learned about performance:
- What is performance, really? It's surprisingly rare to find the elusive person who knows. Travel with me to the jungles of the remote data center and we'll observe one in its native habitat!
- How do you measure performance? It's quite different from things like CPU utilization and cache hit ratios. And you can't optimize what you can't measure, so this is important.
- How can you interpret the measurements and thus find, diagnose, and characterize any performance problems quickly -- or prove there aren't any?
Given the time limitations this will be more how-to than practice, but it's a framework that's served me for a decade, and I've taught it to many people in turn.
- 50 min
- PGConf Local: Philly 2017 [PgConf.US]