Re: Puzzling full database lock - Mailing list pgsql-general

From Christopher Opena
Subject Re: Puzzling full database lock
Date
Msg-id CAFOrgqc3QSHpCUDyg++HRBdYU_CPOKyOMVJBji1n7uqNTwUCCQ@mail.gmail.com
Whole thread Raw
In response to Re: Puzzling full database lock  (Carlos Mennens <carlos.mennens@gmail.com>)
Responses Re: Puzzling full database lock
List pgsql-general
It's CentOS 5.5, PostgreSQL version 9.0.4 (x86_64).

On Wed, Feb 1, 2012 at 4:44 PM, Carlos Mennens <carlos.mennens@gmail.com> wrote:
On Wed, Feb 1, 2012 at 7:38 PM, Christopher Opena <counterveil@gmail.com> wrote:
> Hello folks,
>
> We've been running into some very strange issues of late with our PostgreSQL
> database(s).  We have an issue where a couple of queries push high CPU on a
> few of our processors and the entire database locks (reads, writes, console
> cannot be achieved unless the high CPU query procs are killed).  Further
> investigation shows ~59% total cpu usage (we have 16 total cores), low io,
> and mid-to-low memory usage (we have 74GB of memory, shared_buffers=16GB).

Just out of curiosity, what OS are you running?

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: EXT :Re: Intermittent occurrence of ERROR: could not open relation
Next
From: Carlos Mennens
Date:
Subject: Re: Puzzling full database lock