From: | Condor <condor(at)stz-bg(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Question about load balance |
Date: | 2012-06-13 05:50:22 |
Message-ID: | 2701e30fd8bb6ef54e6217851580ac6a@stz-bg.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 2012-06-12 10:48, John R Pierce wrote:
> On 06/11/12 11:29 PM, Condor wrote:
>> I think I'm trying to learn information what is the technique for
>> managing large databases
>> not to philosophize what was my server.
>
> you handle large databases with a lot of fast disk, and memory, this
> gets you into the terabytes.
>
> clustering/load balancing would not do for this, other than needing
> MORE fast disk (N replicas require N times the disk system of one
> database). clustering can provide active/slave failover for high
> availability, or it can provide replicas for balancing read queries.
> updates have to be made to all the replicas, so they wont be any
> faster than a single server (in fact, will be slower due to the
> overhead of replication
>
> --
> john r pierce N 37, W 122
> santa cruz ca mid-left coast
Thanks, I thought so, but I was not sure whether this is a better
option.
H.
From | Date | Subject | |
---|---|---|---|
Next Message | yatler sahri | 2012-06-13 06:23:25 | Getting this error |
Previous Message | Stefan Schwarzer | 2012-06-13 05:47:25 | Re: Problem installing extensions on Lion |