[Pgpool-general] new connections are not accepted

[Martin Badie]

Thank you very much for enligthening me about this issue

Regards.




________________________________
From: Yoshiharu Mori <y-mori at sraoss.co.jp>
To: Martin Badie <martinbadie at yahoo.com>
Cc: pgpool-general at pgfoundry.org
Sent: Friday, June 5, 2009 10:58:04 AM
Subject: Re: [Pgpool-general] new connections are not accepted


> 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 <y-mori at sraoss.co.jp>
> To: Martin Badie <martinbadie at yahoo.com>
> Cc: pgpool-general at pgfoundry.org
> 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 <y-mori at sraoss.co.jp>
> http://www.sraoss.co.jp/
> 
> 
> 
>      


-- 
SRA OSS, Inc. 日本支社
Yoshiharu Mori <y-mori at sraoss.co.jp>
http://www.sraoss.co.jp/



      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20090605/24b97d10/attachment.html>