[Pgpool-general] pgpool hangs up

[Yoshiyuki Asaba]

Hi,

From: "Max Zorloff" <zorloff at gmail.com>
Subject: Re: [Pgpool-general] pgpool hangs up
Date: Mon, 10 Sep 2007 16:54:12 +0400

> >> I tried pgpool-II 1.2. It's same - hangs up after some time. If I switch
> >> php to use postgres directly, after some time pgpool starts to accept
> >> connections again - and php log says it drops some connections.
> >
> > Could you confirm the parameters? Is it true in your environment?
> >
> >   MaxClients(httpd.conf) <= num_init_children(pgpool.conf)
> 
> Um, what do you mean by "confirm the parameters"?
> No, MaxClients is set to 500 and num_init_children is 5 or 10.

num_init_children is too small. pgpool can accept only 5 or 10
connections. The others are waited.

Then, do you use persistent connections in php?
--
Yoshiyuki Asaba
y-asaba at sraoss.co.jp