Scale factor to workingset size lookup for tiny databases
Scale Factor Working Set Size 1 23M 10 157M 100 1.7GB 1000 15GB 2500 37GB 5000 74GB 10000 147GB
Postgres pgbench scale-factors and WSS
Related Posts
Benchmarking with Postgres PT2
- gary
- June 28, 2019
- 1 min read
- 0
In this example we run pgbench with a scale factor of 1000 which equates to a database size of around […]
Understanding Concurrency Parameters in pgbench
- gary
- January 12, 2021
- 1 min read
- 0
How to use the “jobs” and “clients” parameters in pgbench without going crazy.
Benchmarking with Postgres PT1
- gary
- June 28, 2019
- 2 min read
- 0
In this example, we use Postgres and the pgbench workload generator to drive some load in a virtual machine. Assume […]
Performance gains for postgres on Linux with hugepages
- gary
- March 7, 2019
- 2 min read
- 0
For this experiment I am using Postgres v11 on Linux 3.10 kernel. The goal was to see what gains can […]