pgbench

Run a benchmark test on PostgreSQL. More information: <https://www.postgresql.org/docs/10/pgbench.html>.

Install

All systems
curl cmd.cat/pgbench.sh
Debian Debian
apt-get install postgresql-contrib-9.1
Ubuntu
apt-get install postgresql-contrib-9.3
Alpine
apk add postgresql-contrib
Arch Arch Linux
pacman -S postgresql-old-upgrade
image/svg+xml Kali Linux
apt-get install postgresql-11
CentOS
yum install postgresql-contrib
Fedora
dnf install postgresql-upgrade
Windows (WSL2)
sudo apt-get update sudo apt-get install postgresql-contrib-9.3
Raspbian
apt-get install postgresql-contrib-9.5
Docker
docker run cmd.cat/pgbench pgbench powered by Commando

Run a benchmark test on PostgreSQL. More information: <https://www.postgresql.org/docs/10/pgbench.html>.

  • Initialize a database with a scale factor of 50 times the default size:
    pgbench --initialize --scale=50 database_name
  • Benchmark a database with 10 clients, 2 worker threads, and 10,000 transactions per client:
    pgbench --client=10 --jobs=2 --transactions=10000 database_name

© tl;dr; authors and contributors