It's CentOS 5.5, PostgreSQL version 9.0.4 (x86_64). On Wed, Feb 1, 2012 at 4:44 PM, Carlos Mennens <carlos.menn...@gmail.com>wrote:
> On Wed, Feb 1, 2012 at 7:38 PM, Christopher Opena <counterv...@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? >
