[Pgpool-general] Cluster pgpool-II + PHP

[Cesar Martin]

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
cmartinp at gmail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20100218/22d8f1d6/attachment-0001.html>