[pgpool-general: 458] Re: Tuning for 1000 concurrent connections (load balancing)
ishii at postgresql.org
Wed May 16 02:43:07 JST 2012
> 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
SRA OSS, Inc. Japan
More information about the pgpool-general