From: Kevin Grittner <kgrittn@ymail.com>
To: Josh Berkus <josh@agliodbs.com>
To: eudald_v <reaven.galaeindael@gmail.com>
To: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Sudden connection and load average spikes with postgresql 9.3
Date: Thu, 2 Jul 2015 21:13:47 +0000 (UTC)
Message-ID: <1850894508.1303488.1435871627463.JavaMail.yahoo@mail.yahoo.com> (raw)
In-Reply-To: <55959207.7020906@agliodbs.com>
References: <55959207.7020906@agliodbs.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
Josh Berkus <josh@agliodbs.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
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: kgrittn@ymail.com, josh@agliodbs.com, reaven.galaeindael@gmail.com
Subject: Re: Sudden connection and load average spikes with postgresql 9.3
In-Reply-To: <1850894508.1303488.1435871627463.JavaMail.yahoo@mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox