postgresql, pg_pconnect issues, how to close connection properly
| From: | Julian Tree | Date: | Fri, 08 Sep 2006 18:50:43 +0000 |
| Subject: | postgresql, pg_pconnect issues, how to close connection properly | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-42331@lists.php.net to get a copy of this message | ||
I have a pretty complex data base that runs a lot of aggreated
function (sum, count in addtion to joins) constantly. If I turn off
pg_pconnect, the connection takes too long, if I turn on the
pg_pconnect, the connection eventually max out.
My current solution is to have cron job to restart apache gracefull
every minute.
apachectl gracefulI don't like this solution. Is there a way to reset the connections every so often?