Re: High load average in 64-core server , no I/O wait and CPU is idle - Mailing list pgsql-performance

From Stephen Frost
Subject Re: High load average in 64-core server , no I/O wait and CPU is idle
Date
Msg-id 20120524170912.GQ1267@tamriel.snowman.net
Whole thread Raw
In response to Re: High load average in 64-core server , no I/O wait and CPU is idle  ("Rajesh Kumar. Mallah" <mallah@tradeindia.com>)
Responses Re: High load average in 64-core server , no I/O wait and CPU is idle  (Claudio Freire <klaussfreire@gmail.com>)
List pgsql-performance
* 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

Attachment

pgsql-performance by date:

Previous
From: "Rajesh Kumar. Mallah"
Date:
Subject: Re: High load average in 64-core server , no I/O wait and CPU is idle
Next
From: geirB
Date:
Subject: Re: Any disadvantages of using =ANY(ARRAY()) instead of IN?