PostgreSQL ships with a benchmarking program named pgbench that can be used for a variety of tests. The default tests included are useful, but it also includes a database benchmarking scripting language that allows you to customize these scripts. You can even use the pgbench core as an efficient, scalable multi-client database program to write new tests. There are also some industry-standard tests available that let you compare PostgreSQL with other database products, albeit without officially audited results in most cases.
Topics we will cover in this chapter are:
- PostgreSQL benchmarking tool pgbench
- Built-in pgbench benchmarks
- Custom benchmark using pgbench.