[pgpool-general: 1434] Re: Performance SELECT

[Francesco Di Girolamo]

Pgpool processes :-D


2013/2/26 Francesco Di Girolamo <cicciofrancy at gmail.com>

> 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(")(")
>



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