From: Stephen Frost <sfrost@snowman.net>
To: Rajesh Kumar. Mallah <mallah@tradeindia.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: High load average in 64-core server , no I/O wait and CPU is idle
Date: Thu, 24 May 2012 13:09:12 -0400
Message-ID: <20120524170912.GQ1267@tamriel.snowman.net> (raw)
In-Reply-To: <8120287.465321337878795023.JavaMail.root@zmbox01.trade-india-local.com>
References: <20120524155737.GP1267@tamriel.snowman.net>
<8120287.465321337878795023.JavaMail.root@zmbox01.trade-india-local.com>
* Rajesh Kumar. Mallah (mallah@tradeindia.com) wrote:
> We are running linux with kernel 3.2.X
> (which has the lseek improvements)
Ah, good.
> Thanks for the reference , even i thought so (LockManager) ,
> but we are actually also running out db max connections (also)
> ( which is currently at 600) , when that happens something at
> the beginning of the application stack also gets dysfunctional and it
> changes the very input to the system. ( think of negative feedback systems )
Oh. Yeah, have you considered pgbouncer?
> It is sort of complicated but i will definitely update list ,
> when i get to the point of putting the blame on DB :-) .
Ok. :)
Thanks,
Stephen
Attachments:
signature.asc (application/pgp-signature, 197B) download
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: sfrost@snowman.net, mallah@tradeindia.com
Subject: Re: High load average in 64-core server , no I/O wait and CPU is idle
In-Reply-To: <20120524170912.GQ1267@tamriel.snowman.net>
* 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