Re: Puzzling full database lock

It's CentOS 5.5, PostgreSQL version 9.0.4 (x86_64).

On Wed, Feb 1, 2012 at 4:44 PM, Carlos Mennens <carlos(dot)mennens(at)gmail(dot)com>wrote:

> On Wed, Feb 1, 2012 at 7:38 PM, Christopher Opena <counterveil(at)gmail(dot)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?
>