[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