Re: OT: Performance of VM

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 <andreas(at)a-kretschmer(dot)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.'