Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id 81F12632C34
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Sun, 18 Jul 2010 14:26:19 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 81494-07
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Sun, 18 Jul 2010 17:26:12 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.17.10])
	by mail.postgresql.org (Postfix) with ESMTP id 4D6C2632B63
	for <pgsql-performance@postgresql.org>;
	Sun, 18 Jul 2010 14:26:12 -0300 (ADT)
Received: from pyramid.gregsmith.com
	(static-71-179-240-8.bltmmd.fios.verizon.net [71.179.240.8])
	by mrelayeu.kundenserver.de (node=mreu0) with ESMTP (Nemesis)
	id 0MNhBG-1OgZE72zLW-007LbM; Sun, 18 Jul 2010 19:25:50 +0200
Message-ID: <4C43391B.1040600@2ndquadrant.com>
Date: Sun, 18 Jul 2010 13:25:47 -0400
From: Greg Smith <greg@2ndquadrant.com>
User-Agent: Thunderbird 2.0.0.24 (X11/20100318)
MIME-Version: 1.0
To: Rajesh Kumar Mallah <mallah.rajesh@gmail.com>
CC: Kevin Grittner <Kevin.Grittner@wicourts.gov>,
	Matthew Wakeling <matthew@flymine.org>,
	Craig Ringer <craig@postnewspapers.com.au>,
	pgsql-performance@postgresql.org
Subject: Re: Pooling in Core WAS: Need help in performance tuning.
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>
In-Reply-To: <AANLkTinY4o4EgM7TrYm-CvRwhBqMYbnIBjmZKzIdtq2L@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Provags-ID: V02:K0:kggM8dEnWtORUaE5YhsLTQx0lI67O54OHmBt5RCbIod
	WV0Dy9LcRmapsOKrpNakPhYjjNJ+yd1zAUwUCmmRdwvu6SUQyB
	OwZmeJLjF7gx7MXrK8m++tq/ySYZ7s9b7o9KPzPaImJdv72kZx
	zsGCR/Y23LtDkTKTpRJQ2wsG+BoiQ/uEh3QKGEZ0NrLafY7B0T
	XJSbSkgi8tk8xN9Ar57XIzezjsw0OSq6taijibnx/U=
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9,
	RCVD_IN_DNSWL_NONE=-0.0001
X-Spam-Level: 
X-Archive-Number: 201007/268
X-Sequence-Number: 39657

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