Room: Club Parlor
Learn the basics of setting up and running repeatable benchmarks with pgbench. Whether you are benchmarking your first Postgres performance enhancement or simply want to know what you can do with pgbench, this talk will guide you through considerations for the test system and for designing the benchmark itself. Factors including operating system parameters, filesystem options, Postgres compile options, and your Postgres configuration can all affect benchmark results. Learn how to configure the test system, design a workload, and employ pgbench options which correctly test your desired scenario.