[pgpool-general: 452] Re: Tuning for 1000 concurrent connections (load balancing)
Tatsuo Ishii
ishii at postgresql.org
Tue May 15 21:36:12 JST 2012
> Hi Tatsuo,
>
> thanks for your answer.
> Sorry if I've not been clear.
> If I try to execute 1000 queries the first hundreds (sometimes 700, some
> others just 300) are executed very fast, but the remaining ones are
> executed very slowly.
> Pgpool doesn't fail, it seems just randomly slow.
Sounds like lack of resource, especially memory?
I suggest to run vmstat 1 on the host where pgpool is running on and
to see the swap activities.
--
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