Postgres Pro
Downloads
Home   >   mailing lists

Re: Pooling in Core WAS: Need help in performance tuning. - Mailing list pgsql-performance

From Rajesh Kumar Mallah
Subject Re: Pooling in Core WAS: Need help in performance tuning.
Date
Msg-id AANLkTimSW9UqtxnEiwDHJyBtXGkgJxmxQHCSinpo1bDs@mail.gmail.com
Whole thread Raw
In response to Re: Pooling in Core WAS: Need help in performance tuning.  (Greg Smith <greg@2ndquadrant.com>)
List pgsql-performance
Tree view
ok ,
now the question is , is it possible to dig out from from postgresql database
server if connection pooling is needed ? In our case eg i have kept
max_connections = 300  if i reduce below 250 i get error "max connection reached....."
on connecting to db directly,  if i put pgbouncer i get less performance
(even if no clients waiting)

without pooling the dbserver CPU usage increases but performance of apps
is also become good.

Regds
Rajesh Kumar Mallah.

On Sun, Jul 18, 2010 at 10:55 PM, Greg Smith <greg@2ndquadrant.com> wrote:
Rajesh Kumar Mallah wrote:
the no of clients was 10 ( -c 10)  carrying out 10000 transactions each (-t 10000) .
pgbench db was initilised with scaling  factor -s 100.

since client count was less there was no queuing of requests in pgbouncer
i would prefer to say  it was in 'passthrough' mode.

Of course pgbouncer is going decrease performance in this situation.  You've added a whole layer to things that all traffic has to pass through, without a setup that gains any benefit from the connection pooling.  Try making the client count 1000 instead if you want a useful test.

--
Greg Smith  2ndQuadrant US  Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com   www.2ndQuadrant.us


pgsql-performance by date:

Previous
From: Greg Smith
Date:
Subject: Re: Pooling in Core WAS: Need help in performance tuning.
Next
From: Rajesh Kumar Mallah
Date:
Subject: Re: Pooling in Core WAS: Need help in performance tuning.