Postgres FM Benchmarking
Feb 10, 2023
Guests Alexander Korotkov, Andres Freund, and Nikolay discuss the importance of benchmarking in databases. They cover topics like conducting experiments, system limits, query optimization, and realistic workloads. They also mention specific tools like PG bench and JMeter, as well as case studies and references to books on system performance.
Chapters
Transcript
Episode notes
1 2 3 4 5 6
Introduction
00:00 • 4min
Different Scenarios for Benchmarking in Decision-Making
03:59 • 16min
Postgres extension for monitoring and query optimization
20:22 • 3min
Benchmarking Process and System Performance
23:04 • 10min
Benchmarks and Case Studies in Postgres and Database Management Systems
32:50 • 2min
Understanding system internals and the importance of benchmarking
35:08 • 2min