Re: Monitoring number of backends

On 10/22/2013 11:25 AM, andy wrote:
> Hum.. I had not thought of that. My current setup uses 40 max
> connections, and I don't think I've ever hit it. I use apache and
> php, and my db connections are not persistent.

that style of php programming, you're getting some HUGE overhead in
connect/disconnect per web page. putting pg_bouncer in the middle
will make a HUGE improvement, possibly a second per page load on a busy
server.

You can even set it up in parallel with things live... first install
pgbouncer, and configure it to listen on an alternate port, say 15432,
and verify you can connect and everything looks good (psql -p 15432...)
then tweak your PHP app's database config to use that port instead of
5432...

--
john r pierce 37N 122W
somewhere on the middle of the left coast