Search Postgresql Archives

Re: Question about load balance

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux