pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Greg Smith <greg@2ndquadrant.com>
To: Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
Cc: Kevin Grittner <Kevin.Grittner@wicourts.gov>
Cc: Matthew Wakeling <matthew@flymine.org>
Cc: Craig Ringer <craig@postnewspapers.com.au>
Cc: pgsql-performance@postgresql.org
Subject: Re: Pooling in Core WAS: Need help in performance tuning.
Date: Sun, 18 Jul 2010 13:25:47 -0400
Message-ID: <4C43391B.1040600@2ndquadrant.com> (raw)
In-Reply-To: <AANLkTinY4o4EgM7TrYm-CvRwhBqMYbnIBjmZKzIdtq2L@mail.gmail.com>
References: <AANLkTiknhZhKtGDidBsMWtPJpRgln9DrrsCebCEYk5XE@mail.gmail.com>
	<4C369346.6010501@postnewspapers.com.au>
	<AANLkTin4Q4APRnbJ85FRasU7n8LuhKibKYcGnexsEbTt@mail.gmail.com>
	<8760.1278650566@sss.pgh.pa.us>
	<1278680186.1914.36.camel@bnicholson-desktop>
	<4C36F57102000025000332F6@gw.wicourts.gov>
	<alpine.DEB.2.00.1007091621380.2534@aragorn.flymine.org>
	<4C36FEAD02000025000332FC@gw.wicourts.gov>
	<alpine.DEB.2.00.1007091753350.2534@aragorn.flymine.org>
	<4C37A9C1.1060405@2ndquadrant.com>
	<4C37791C0200002500033379@gw.wicourts.gov>
	<4C37CBFB.1000800@agliodbs.com>
	<4C37EA1D.6000008@postnewspapers.com.au>
	<AANLkTimNJZlX7kFH_r0-BB_K3NGorU7BHd85SxXJbuGJ@mail.gmail.com>
	<4C38BF03.6060503@agliodbs.com>
	<19244.1278787866@sss.pgh.pa.us>
	<alpine.DEB.2.00.1007121044330.2534@aragorn.flymine.org>
	<4C3AF564.5030204@postnewspapers.com.au>
	<4C3AC73002000025000333ED@gw.wicourts.gov>
	<AANLkTinY4o4EgM7TrYm-CvRwhBqMYbnIBjmZKzIdtq2L@mail.gmail.com>

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




view thread (59+ messages)  latest in thread

Message-ID: <4C43391B.1040600@2ndquadrant.com>
Permalink:  ../4C43391B.1040600@2ndquadrant.com/
Also on:    postgresql.org/message-id/4C43391B.1040600@2ndquadrant.com

 · 

reply
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: greg@2ndquadrant.com, mallah.rajesh@gmail.com, Kevin.Grittner@wicourts.gov, matthew@flymine.org, craig@postnewspapers.com.au
  Subject: Re: Pooling in Core WAS: Need help in performance tuning.
  In-Reply-To: <4C43391B.1040600@2ndquadrant.com>

* 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