Tuning Hardware and the Operating System: Benchmarking on PostgreSQL
summary
A practical look at benchmarking PostgreSQL for performance tuning of hardware and the OS. Covers why benchmarks matter, what benefits they bring, common pitfalls encountered when running benchmarks, and lessons learned from real-world attempts to optimize Java-related database workloads.
AI-written summary · about
chapters (14)
- 0:00Introduction
- 2:04About the speaker
- 3:09Database benchmarking issues
- 7:07HammerDB benchmark analysis
- 15:01Row update benchmark
- 18:18Benchmark noise
- 19:00Hardware and BIOS tuning
- 22:10CPU driver optimization
- 23:14CPU process migration off
- 25:04Process pinning to cores
- 26:11Disk subsystem tuning
- 27:15System tuning conclusions
- 27:36PostgreSQL tuning
- 33:17Conclusion
related talks
31mDemanding the impossible rigorous database benchm
50mPerformance Archaeology
44mDemystifying Benchmarks: How to Use Them To Better Evaluate Databases
51mPostgreSQL: Practical Examples of SQL Query Optimization
29mPerformance Archaeology - 20 years of improvements
41mOptimizing your app by understanding your PostgreSQL database
46mOptimizing High-Contention Writes in PostgreSQL
43mPostgreSQL in the cloud: Theory and Practice