[pgpool-general: 1430] Re: Performance SELECT

Tatsuo Ishii ishii at postgresql.org
Tue Feb 26 09:27:20 JST 2013

> Is there a guide about performance setting by hardware ? I have an hard
> decrement in my select queries. I used streaming replication on two windows
> server with PG 8.3. Sorry but client's requisites do not permit to migrate
> to Linux. :-(

There's no performance documentation yet. However I think the major
bottle neck is network, including netowrk hardware and TCP/IP stack.

Also too trivial SELECT (like pgbench -S) will mask the effect of
pgpool performance boosting in load balancing.
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

More information about the pgpool-general mailing list