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…
Tag: postgres
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
1 min read
0
How to measure database scaling & density on Nutanix HCI platform.
How can database density be measured? How does database performance behave as more DBs are consolidated? What impact does running…
1 min read
0
Measuring CPU performance with X-Ray and pgbench.
An X-ray workload for measuring application density
1 min read
0
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
Install a bitnami image to Nutanix AHV cluster.
One of the nice things about using public cloud is the ability to use pre-canned application virtual appliances created by…
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…