Hello there, We do have a cluster with pgpool-II 2.3 and 2 backend Postgres 8.3.9 runing in Centos 5.4 with max_connections=200. This cluster is used by web apllication in PHP 5.2 that connects to DB with pg_pconnect and always with same user. I do have a couple of doubts...
I have been reading about the problems of pg_pconnect with pgpool and we are going to change the connections to pg_connect. The problem is that at the moment we don't have time to change all the code before the system go to produccion. I also saw that if your application access the DB always with the same user, it will be the best to set max_pool = 1 in pgpool.conf. Based on these guidelines, I think the best configuration in my case is set num_init_children = 200 and max_pool = 1, is that correct? When we do change the connection to the pg_connect should I keep these values? My other question is, the maintenance tasks reindex and vacuum, should be made over pgpool or over each backend? Thanks in advance. Best regards. -- César Martín [email protected]
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
