Tag: postgres

Understanding Concurrency Parameters in pgbench
By: Date: January 12, 2021 Categories: Workloads & Benchmarks Tags: , ,

pgbench paramaters for concurrency control pgbench offers two parameters for controlling the concurrency in the benchmark. Namely: -j for ‘jobs’. The number of pgbench threads to run. -j, –jobs=NUM number of threads (default: 1) -c for ‘clients’. The number of “postgres” processes to run. -c, –client=NUM number of concurrent database clients (default: 1) Here are…

Read More →
How to measure database scaling & density on Nutanix HCI platform.
By: Date: March 27, 2020 Categories: Nutanix Tags: , , ,

How can database density be measured? How does database performance behave as more DBs are consolidated? What impact does running the CVM have on available host resources? tl;dr The cluster was able to achieve ~90% of the theoretical maximum. CVM overhead was 5% for this workload. Experiment setup The goal was to establish how database…

Read More →
Benchmarking with Postgres PT1
By: Date: June 28, 2019 Categories: Postgres Tags: , ,

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…

Read More →
Install a bitnami image to Nutanix AHV cluster.
By: Date: June 28, 2019 Categories: Nutanix Tags: , , , ,

One of the nice things about using public cloud is the ability to use pre-canned application virtual appliances created by companies like Bitnami. We can use these same appliance images on Nutanix AHV to easily do a Postgres database benchmark Step 1. Get the bitnami image wget  https://bitnami.com/redirect/to/587231/bitnami-postgresql-11.3-0-r56-linux-debian-9-x86_64.zip Step 2. Unzip the file and convert…

Read More →