Re: High load average every 105 minutes

From: Nhan Nguyen <nhan(dot)nguyen(at)inspireventures(dot)com>
To: John R Pierce <pierce(at)hogranch(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: High load average every 105 minutes
Date: 2016-11-07 06:45:08
Message-ID: 9808EE93-7272-4F4E-86EB-4E8FDA067F14@inspireventures.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks for the reply.
I found no strange processes or queries while load average was at peak. IO also didn't change. Some more slow queries were logged, but not many.
I think sharing the VM with other customers doesn’t have much to do with this. I checked my other servers too, and only those that have postgresql have the load average issue. Generally it doesn’t impact my system much, but when there are slow queries, this issue just makes everything worse.

Nhan Nguyen
System Engineer

MB: (+84) 934 008 031
Skype: live:ducnhan813

> On Nov 4, 2016, at 4:03 PM, John R Pierce <pierce(at)hogranch(dot)com> wrote:
>
> On 11/4/2016 1:45 AM, Nhan Nguyen wrote:
>>
>> The load average of the instance increase every 105 minutes even without any database. I’ve checked the scheduled jobs but couldn’t find anything suspicious. When the load average was at peak, I couldn’t see any process consuming resources. This happens on all my servers that has postgresql installed, even after I purge postgresql. Has anyone seen this before
>
> load average doesn't mean much other than the number of processes waiting for a resource. does the IO latency spike at this time, too?
>
> with AWS, your system is sharing the vendors virtual machine environment with other customers, and performance is pretty much out of your control.
>
> --
> john r pierce, recycling bits in santa cruz
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Chris Mair 2016-11-07 09:54:31 Re: High load average every 105 minutes
Previous Message amul sul 2016-11-07 06:06:24 Re: Exclude pg_largeobject form pg_dump