> Yoshiharu I am very new to pgpool but I think maximum number of connection > allowed in a certain time is num_init_chidren x max_pool (which is in my > case 40x32?) > Am I wrong?
Yes you are wrong. The "one" pgpool process can hold the connections from pgpool to postgres which number is defined by max_pool. But the number of connection from acplication to pgpool is defined by num_init_children. One pgpool process can handle one pooled connection simultaneously. The other pooled connections were only cached. > > # number of pre-forked child process > num_init_children = 40 > > # Number of connection pools allowed for a child process > max_pool = 32 > > > > > ________________________________ > From: Yoshiharu Mori <[email protected]> > To: Martin Badie <[email protected]> > Cc: [email protected] > Sent: Friday, June 5, 2009 9:39:56 AM > Subject: Re: [Pgpool-general] new connections are not accepted > > Hi > > > Hi, > > Yes my application uses persistent connections.How can I found out how many > > connections are used in a certain time > > Simply, ps auxwww or netstat -nap | grep pgpool > > > and how can I detect maximum > > simultaneous connections from pgpool.conf so I can tweak my application > > for that maximum connection number. > > "num_init_children" is maximum simultaneous connection number. > > -- > SRA OSS, Inc. Japan > Yoshiharu Mori <[email protected]> > http://www.sraoss.co.jp/ > > > > -- SRA OSS, Inc. 日本支社 Yoshiharu Mori <[email protected]> http://www.sraoss.co.jp/ _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
