[Pgpool-general] problems with adodb

[Jaime Casanova]

On Fri, Nov 28, 2008 at 8:57 PM, Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
> Can you provide more details?
>
> What version of pgpool? pgpool.conf? What do you see if you start
> pgpool with -d (debug) option?

sorry for the delay, the pgpool.conf in test env was unchahnged
(except for the backend_hostname0 and the backend_port0)... in
production besides the backend_*0 parameters we set num_init_children
to 256  and max_pool to 8...

tests seems to show that the problem is that php (or the adodb driver)
is making persistent connections no matter if i use: Connect NConnect
or PConnect (every one of one traduces to one of pg_connect or
pg_pconnect depending on parameters)...

the problem is because connections stay in idle in pgpool for a long
time, maybe i can stablish client_idle_limit to a reasonably value. 30
seconds seems like a good idea for a web page?

-- 
Atentamente,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Asesoría y desarrollo de sistemas
Guayaquil - Ecuador
Cel. +59387171157