2 min read
0
Notes on tuning postgres for cpu and memory benchmarking
Recently I wanted to measure the impact of NUMA placement and Hugepages on the performance of postgres running in a…
Category: Postgres
Testing and Benchmarking PostgresDB
1 min read
0
Understanding Concurrency Parameters in pgbench
How to use the “jobs” and “clients” parameters in pgbench without going crazy.
1 min read
0
Postgres pgbench scale-factors and WSS
Scale factor to workingset size lookup for tiny databases
2 min read
0
View from Nutanix storage during Postgres DB benchmark
Following on from the previous [1] [2] experiments with Postgres & pgbench. A quick look at how the workload is…
1 min read
0
Benchmarking with Postgres PT2
In this example we run pgbench with a scale factor of 1000 which equates to a database size of around…
2 min read
0
Benchmarking with Postgres PT1
In this example, we use Postgres and the pgbench workload generator to drive some load in a virtual machine. Assume…
2 min read
0
Performance gains for postgres on Linux with hugepages
For this experiment I am using Postgres v11 on Linux 3.10 kernel. The goal was to see what gains can…