Have them check the memory and CPU allocation of the hypervisor, make sure its not overallocated. Make sure the partitions for stroage are aligned (see here: https://blogs.vmware.com/vsphere/2011/08/guest-os-partition-alignment.html) . Install tuned, and enable the throughput performance profile. Oracle has a problem with transparent hugepages, postgres may well have the same problem, so consider disabling transparent hugepages. There is no reason why performance on a VM would be worse than performance on a physical server.
On Mon, Feb 5, 2018 at 7:26 AM, Andreas Kretschmer <andr...@a-kretschmer.de> wrote: > > > Am 05.02.2018 um 14:14 schrieb Thomas Güttler: > >> What do you suggest to get some reliable figures? >> > > sar is often recommended, see https://blog.2ndquadrant.com/i > n-the-defense-of-sar/. > > Can you exclude other reasons like vacuum / vacuum freeze? > > > > Regards, Andreas > > -- > 2ndQuadrant - The PostgreSQL Support Company. > www.2ndQuadrant.com > > > -- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.'
