Benchmark: PostgreSQL
1. Prepare test database
# su - postgres
$ psql
create database test;
\q
2. Buffer test (scale / 75 = 1GB database)
pgbench -i -s 15 test
pgbench -T 600 test
3. Cache test
pgbench -i -s 70 test
pgbench -T 600 test
4. Disk test
pgbench -i -s 600 test
pgbench -T 600 test
Single-client benchmark
pgbench -i -s 64 benchmark -h localhost -U foo
pgbench -c 1 -j 1 -t 10000 -h localhost -U foo -d test
Scaling factor
| Test | Formula |
|---|---|
| Buffer test | SYS_MEMORY * 0.003 |
| Mostly cache | SYS_MEMORY * 0.2 |
| On disk | SYS_MEMORY * 0.6 |
Resources
Performance testing: wiki
Phoronix test suite pgbench profile: link