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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
