Tag: postgres

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 →
Impact of Data locality on DB workloads.
By: Date: July 23, 2019 Categories: Nutanix Tags: ,

In this video I migrate a Postgres DB running PGbench benchmark. The DB is running on a Host which is CPU constrained. Once the VM is migrated to a less busy host the transaction rate immediately increases from ~15,000 to ~20,000. As the DB continues to run on the new host – the Nutanix storage…

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 →