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

[Tatsuo Ishii]

> On 15/05/12 15:24, Tatsuo Ishii wrote:
>> Yes, no swap in/out and almost see no activies.
>>
>>
>> If you lower num_init_children, do you see any performance improvement?
>>
> Weird, I've tried with num_init_children = 350, keeping max_pool = 2, 
> and it seems working!
> 350*2 = 750, how it can handle 1000 connections?

It simply does queueing. pgpool-II uses listen(2) to accept incoming
connection requests from clients. If num_init_children = 350, then
pgpool-II can accept simulately 350 connections (not 350*2 = 700). The
350+1 th incoming connection will be delayed in the kernel queue until
one of 350 existing connections is terminated thus it starts to accept
new connection.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp