I just want to confirm something with all you smart folks.
I recently separated my web servers from my database servers, before I was
using Apache::DBI to maintain persistent connections between Apache and
Postgres. With this new setup I had to install PgBouncer. Can I now safely
remove
I'd be interested in hearing about this too.
On Tue, Apr 22, 2014 at 10:02 AM, jbiskofski jbiskof...@gmail.com wrote:
I just want to confirm something with all you smart folks.
I recently separated my web servers from my database servers, before I was
using Apache::DBI to maintain
Apache::DBI caches database connection per process so you avoid the cost of
creating a connection on each requests.
Pgbouncer pools database connections so that you don't tie up one
postmaster process per httpd process.
If you only have one webserver you may not have a real need for pgbouncer;
Interesting. Why did you have to install PgBouncer? Can't Postgres
handle remote connections from your web server?
I don't use Postgres, but reading the description of PgBouncer I can
see some things you'd want to consider.
First, Apache::DBI prevents you from making persistent connections
I can speak to your final point. I recently deployed PGBouncer into our
production environment and, like the OP, we have separate web and database
servers. With PGBouncer running on the web server(you could also run it on
the database server if you wanted to) we noticed a dramatic increase in
Thanks John. Were you using Apache::DBI before PgBouncer?
Apache::DBI would also eliminate the overhead of establishing new
connections.
- Perrin
On Tue, Apr 22, 2014 at 12:23 PM, John Dunlap j...@lariat.co wrote:
I can speak to your final point. I recently deployed PGBouncer into our
use Apache::DBI (); appears in our startup.pl but the application code uses
DBI directly.
On Tue, Apr 22, 2014 at 12:30 PM, Perrin Harkins phark...@gmail.com wrote:
Thanks John. Were you using Apache::DBI before PgBouncer?
Apache::DBI would also eliminate the overhead of establishing new
using Apache::DBI before PgBouncer?
Apache::DBI would also eliminate the overhead of establishing new
connections.
- Perrin
On Tue, Apr 22, 2014 at 12:23 PM, John Dunlap j...@lariat.co wrote:
I can speak to your final point. I recently deployed PGBouncer into our
production environment
phark...@gmail.com
wrote:
Thanks John. Were you using Apache::DBI before PgBouncer?
Apache::DBI would also eliminate the overhead of establishing new
connections.
- Perrin
On Tue, Apr 22, 2014 at 12:23 PM, John Dunlap j...@lariat.co wrote:
I can speak to your final point. I