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