Re: OT: Performance of VM
От | Andrew Kerber |
---|---|
Тема | Re: OT: Performance of VM |
Дата | |
Msg-id | CAJvnOJbzmAiwytvpAkLaDC2Y4p=VS+1A_2qou7pyBU5bQPX5CQ@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: OT: Performance of VM (Andreas Kretschmer <andreas@a-kretschmer.de>) |
Ответы |
Re: OT: Performance of VM
Re: OT: Performance of VM |
Список | 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.'
'If at first you dont succeed, dont take up skydiving.'
В списке pgsql-performance по дате отправления: