On Fri, Nov 28, 2008 at 8:57 PM, Tatsuo Ishii <[EMAIL PROTECTED]> 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 _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
