On Wed, Feb 1, 2012 at 7:38 PM, Christopher Opena <counterveil@xxxxxxxxx> 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). Define "low I/O". The only things I've ever seen interfere with console access are running out of memory or excessive disk i/o. If you're seeing even 6-12% iowait on a 16 core machine you might very well have swamped your available disk I/O. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
