On 2012-06-08 08:39, Craig Ringer wrote:
On 06/07/2012 10:26 PM, Condor wrote:
Hello ppl,

I read in internet and in this mailing list, when some one asking about load balance,
most of the answers is: pgpool.
I want to asking how stable is pgpool ? How much query can handle ? What load average ?
Im looking for something multi master solution.

PgPool-II doesn't offer mutli-master operation. Not much does.

Multi-master is very difficult to get right, and even harder to make fast.

Are you really sure it's what you want? Failover is often a much,
MUCH simpler and more efficient approach.

--
Craig Ringer

No,
Im not sure, just looking how to make load balance. I have a small database around 20 gb, but I expect to join another database on different scheme and Im looking for solution about load balance or some cache mechanism. Bad part is one row from db is read once in a month, in worst scenario 3-4 times in month and I think cache is not good option,
but I don't have idea how will work.


H.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to