Re: OT: Performance of VM - Mailing list pgsql-performance

From Andrew Kerber
Subject Re: OT: Performance of VM
Date
Msg-id CAJvnOJbzmAiwytvpAkLaDC2Y4p=VS+1A_2qou7pyBU5bQPX5CQ@mail.gmail.com
Whole thread Raw
In response to Re: OT: Performance of VM  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Responses Re: OT: Performance of VM  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Re: OT: Performance of VM  (Robert Klemme <shortcutter@googlemail.com>)
List pgsql-performance
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@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/in-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.'

pgsql-performance by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: OT: Performance of VM
Next
From: Andreas Kretschmer
Date:
Subject: Re: OT: Performance of VM