On 11/02/18 00:20, Robert Klemme wrote:
On Mon, Feb 5, 2018 at 5:22 PM, Andrew Kerber wrote:
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/g
+1 for atop. Be sure to adjust the sampling interval so it suits your
needs. It'll tell you what caused the spike.
Alternatively you could probably use sysdig, but I expect that'd result in
a fair performance hit if your system is already struggling.
Micky
On 14 February 2018 at 08:15, Gunnar "N
Am 06.02.2018 um 15:31 schrieb Thomas Güttler:
>
>
> Am 05.02.2018 um 14:26 schrieb Andreas Kretschmer:
>>
>>
>> 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
I am consultant that specializes in virtualizing oracle enterprise level
workloads. I’m picking up Postgres as a secondary skill. You are right if you
don’t manage it properly, you can have problems running enterprise workloads on
vm s. But it can be done with proper management. And the HA and
On Mon, Feb 5, 2018 at 5:22 PM, Andrew Kerber wrote:
> 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)
> .
On Tue, 2018-02-06 at 15:31 +0100, Thomas Güttler wrote:
>
But one thing is still unclear. Imagine I see a peak in the chart. The peak
> was some hours ago. AFAIK sar has only the aggregated numbers.
>
> But I need to know details if I want to answer the question "Why?". The peak
> has gone
Am 05.02.2018 um 14:26 schrieb Andreas Kretschmer:
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
Am 05.02.2018 um 17:22 schrieb Andrew Kerber:
Oracle has a problem with transparent hugepages, postgres may well
have the same problem, so consider disabling transparent hugepages.
yes, that's true.
Regards, Andreas
--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com
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. O
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 PostgreSQ
This is a bit off-topic, since it is not about the performance of PG itself.
But maybe some have the same issue.
We run PostgreSQL in virtual machines which get provided by our customer.
We are not responsible for the hypervisor and have not access to it.
The IO performance of our application
11 matches
Mail list logo
