[pgpool-general: 1433] Re: Performance SELECT

Francesco Di Girolamo cicciofrancy at gmail.com
Tue Feb 26 22:59:47 JST 2013


Instead when i execute simultaneous async queries (select) with AJAX, i
notice my server use a lot of processes. These processes use resources. Is
only the hardware and the net its bottleneck ?
thk a lot
Franz


2013/2/26 Tatsuo Ishii <ishii at postgresql.org>

> > 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
>



-- 
*Franci anni'80*
♫
(\ /)
( . .) ♥●•٠·˙
c(")(")
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130226/4413bbcf/attachment.html>


More information about the pgpool-general mailing list