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 →