Performance on Hypervisor Products
To achieve the best performance for PSQL, ensure the following:
•
Adherence to the performance best practices recommendations from the hypervisor vendor.
•
The VM hosting PSQL has ample memory (RAM).
•
The hypervisor host has enough virtual CPUs to minimize virtual CPU contention among all of the VMs on the same machine. This prevents contention with the VM running PSQL. If you use affinity rules, ensure that all cores are running on the same socket.
•
The PSQL data files reside on very fast physical storage and minimize spindle contention and controller contention for the physical storage device.