Postgres pgbench scale-factors and WSS

Published: (Updated: ) in Postgres, , by . Leave a Comment on Postgres pgbench scale-factors and WSS.

Scale factor to workingset size lookup for tiny databases

Measuring CPU performance with X-Ray and pgbench.

Published: (Updated: ) in Postgres, , by .

An X-ray workload for measuring application density

View from Nutanix storage during Postgres DB benchmark

Published: (Updated: ) in Nutanix, Postgres, , by .

Following on from the previous [1] [2] experiments with Postgres & pgbench. A quick look at how the workload is seen from the Nutanix CVM. The Linux VM running postgres has two virtual disks: One is taking transaction log writes. The other is doing reads and writes from the main datafiles. Since the database size […]

Benchmarking with Postgres PT2

Published: (Updated: ) in Postgres, , , by .

In this example we run pgbench with a scale factor of 1000 which equates to a database size of around 15GB. The linux VM has 32G RAM, so we don’t expect to see many reads. Using prometheus with the Linux node exporter we can see the disk IO pattern from pgbench. As expected the write […]

Benchmarking with Postgres PT1

Published: (Updated: ) in Postgres, , , by .

In this example, we use Postgres and the pgbench workload generator to drive some load in a virtual machine. ¬†Assume a Linux virtual machine that has Postgres installed. Specifically using a Bitnami virtual appliance. Once the VM has been started, connect to the console Allow access to postgres port 5432 – which is the postgres […]