[pgpool-general: 450] Re: Tuning for 1000 concurrent connections (load balancing)

Tatsuo Ishii ishii at postgresql.org
Tue May 15 20:54:38 JST 2012


What do you mean "no working properly"? Can you elaborate more?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> Hi,
> I've been struggling with the configuration of pgpool and postgresql for 
> days.
> I need to handle 1000 concurrent connections (1000 spatial queries) at 
> the same time.
> The available hardware is composed of four dedicated servers, all of 
> them with 24Gb ram and SSD HDs.
> I've set num_init_children to 1000, max_pool to 2 and the 
> max_connections parameter to 2000 on each server but it seems not 
> working properly.
> Any suggestions?
> 
> Thanks,
> A.
> 
> -- 
> Alessandro De Noia
> GIS Developer
> 
> e: alessandro at piemapping.com | w: www.piemapping.com
> Caledonia House, 223 - 231 Pentonville Road, London, N1 9NG
> 
> Please don't print this e-mail unless you really need to
> 
> PIE trading name of MPIE Limited, is a company registered in England and Wales with company number 6991293. Vat number: 983340996
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general


More information about the pgpool-general mailing list