Benchmarking databases is a very extensive topic, and this chapter just introduces the major concepts. Having the
pgbench tool bundled with the database is handy for doing smaller tests, but you need to be careful of its limitations before you rely too much on its results for your tuning efforts.
pgbenchtests is outdated, and it's unlikely to match real-world performance. It can still be useful as a synthetic performance test.
pgbenchtables or new ones, and use the
pgbenchscripting capability to run those tests against multiple clients at once.
pgbenchresults, since its queries are ...