Re: Sudden connection and load average spikes with postgresql 9.3

From: Kevin Grittner <kgrittn(at)ymail(dot)com>
To: Josh Berkus <josh(at)agliodbs(dot)com>, eudald_v <reaven(dot)galaeindael(at)gmail(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Sudden connection and load average spikes with postgresql 9.3
Date: 2015-07-02 21:13:47
Message-ID: 1850894508.1303488.1435871627463.JavaMail.yahoo@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Josh Berkus <josh(at)agliodbs(dot)com> wrote:
> On 07/02/2015 08:41 AM, eudald_v wrote:

>> And this is how it looks like when the spike happens:
>> [system CPU staying over 90%]

> I think you have a driver, kernel, Linux memory management, or IO
> stack issue.

In my experience this is usually caused by failure to disable
transparent huge page support. The larger shared_buffers is
configured, the bigger the problem.

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2015-07-02 23:04:51 Re: Sudden connection and load average spikes with postgresql 9.3
Previous Message Josh Berkus 2015-07-02 19:33:27 Re: Sudden connection and load average spikes with postgresql 9.3