[pgpool-general: 1802] Re: pgpool vs. pgbouncer

[Tatsuo Ishii]

> On 05/26/2013 08:29 AM, Jeff Frost wrote:
>>
>> I think pgbouncer will really shine when it is running locally on the
>> application server with a separate PostgreSQL server.
>>
>> Also, I'm not sure 10 clients with 1 thread is large enough contention
>> to push the performance of either pgpool or pgbouncer.
> 
> Agreed. Although I do think seeing the slower portion of pgbench is
> interesting for the standard pooling case. I wonder, does pgpool-ii
> parse even when in just pooling mode?

Yes.

BTW, by knowing that pgbouncer's transaction mode is alomost 40%
slower than session mode, I noticed what people wants to have is not
just throughput, but the ability to allow large number of concurrent
connections unless pgbouncers's user rarely use the transaction mode.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp