From: | John R Pierce <pierce(at)hogranch(dot)com> |
---|---|
To: | PostgreSQL <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Question about load balance |
Date: | 2012-06-12 07:48:08 |
Message-ID: | 4FD6F438.9080500@hogranch.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Stefan Schwarzer | 2012-06-12 12:21:23 | Problem installing extensions on Lion |
Previous Message | Craig Ringer | 2012-06-12 07:40:33 | Re: Segmentation Fault |