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 →
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 →