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
-
apt-get install postgresql-contrib-9.1
- Ubuntu
-
apt-get install postgresql-contrib-9.3
- Alpine
-
apk add postgresql-contrib
- Arch Linux
-
pacman -S postgresql-old-upgrade
- 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
- Dockerfile
- dockerfile.run/pgbench
- 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