LinuxCommandLibrary

pgbench

Run a benchmark test on PostgreSQL.

TLDR

Initialize a database with a scale factor of 50 times the default size

$ pgbench --initialize --scale=[50] [database_name]
copy


Benchmark a database with 10 clients, 2 worker threads, and 10,000 transactions per client
$ pgbench --client=[10] --jobs=[2] --transactions=[10000] [database_name]
copy

Copied to clipboard