[pgpool-general: 1079] Re: Performance Several Databases
wolf at uen.org
Sat Oct 6 01:09:17 JST 2012
I would start with this doc http://www.pgpool.net/docs/latest/tutorial-en.html. This is what I did, then move to having two pgpool servers running watchdog with primary and replication database servers.
Here's the link for watchdog: http://www.pgpool.net/pgpool-web/contrib_docs/watchdog/en.html#Top
From: pgpool-general-bounces at pgpool.net [mailto:pgpool-general-bounces at pgpool.net] On Behalf Of Erik Czumadewski
Sent: Friday, October 05, 2012 9:55 AM
To: pgpool-general at pgpool.net
Subject: [pgpool-general: 1078] Performance Several Databases
We have problems with scalation of our databases, we have one postgresql server (Dell PowerEdge R815, 32 CPU, 128 G of ram) with 2000 diferent databases, and we need one method to "distribute" the charge of the postgresql in various servers, we are intrested in pgpool, but we don't have one "big" database to distribute, we have several small-medium databases 2000 +- so we need to know experiences, or some idea if pgpool can help us to distribute our postgresql server in various servers and improve the performance and have a backup of the data.
Thanks for all your answers.
pgpool-general mailing list
pgpool-general at pgpool.net
More information about the pgpool-general