<div dir="ltr">Pgpool processes :-D</div><div class="gmail_extra"><br><br><div class="gmail_quote">2013/2/26 Francesco Di Girolamo <span dir="ltr"><<a href="mailto:cicciofrancy@gmail.com" target="_blank">cicciofrancy@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">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 ?<div>
thk a lot</div>
<div>Franz</div></div><div class="gmail_extra"><div><div class="h5"><br><br><div class="gmail_quote">2013/2/26 Tatsuo Ishii <span dir="ltr"><<a href="mailto:ishii@postgresql.org" target="_blank">ishii@postgresql.org</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div>> Is there a guide about performance setting by hardware ? I have an hard<br>
> decrement in my select queries. I used streaming replication on two windows<br>
> server with PG 8.3. Sorry but client's requisites do not permit to migrate<br>
> to Linux. :-(<br>
<br>
</div>There's no performance documentation yet. However I think the major<br>
bottle neck is network, including netowrk hardware and TCP/IP stack.<br>
<br>
Also too trivial SELECT (like pgbench -S) will mask the effect of<br>
pgpool performance boosting in load balancing.<br>
--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
Japanese: <a href="http://www.sraoss.co.jp" target="_blank">http://www.sraoss.co.jp</a><br>
</blockquote></div><br><br clear="all"><div><br></div></div></div><div class="im">-- <br><i style="font-family:courier new,monospace">Franci anni'80</i><br><h6><span>♫<br>(\ /) <br>( . .) ♥●•٠·˙ <br>c(")(")</span></h6>
<br><div style="display:inline">
</div>
</div></div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><i style="font-family:courier new,monospace">Franci anni'80</i><br><h6><span>♫<br>(\ /) <br>( . .) ♥●•٠·˙ <br>c(")(")</span></h6><br><div style="display:inline">
</div>
</div>