PG Bench as a Load Testing Tool

In the presentation, we explore PostgreSQL's powerful performance testing tool – pg_bench, and examine two practical cases. You will learn how pg_bench not only assists in evaluating the overall performance of databases but also in finely tuning and optimising user queries. We will demonstrate the crucial role of ANALYZE in eliminating inaccuracies during load testing.

The presentation aims to provide practical knowledge on how pg_bench can become your tool for a deeper understanding of database operations and their efficient configuration without the need for full-scale load testing.