[pgpool-general: 1430] Re: Performance SELECT

[Tatsuo Ishii]

> 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