[pgpool-general: 1079] Re: Performance Several Databases

[Wolf Schwurack]

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 

Wolf


-----Original Message-----
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

Hello readers,

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.

Erik Czumadewski
Departamento NOC
Desis

_______________________________________________
pgpool-general mailing list
pgpool-general at pgpool.net
http://www.pgpool.net/mailman/listinfo/pgpool-general