Re: Hardware/OS recommendations for large databases ( - Mailing list pgsql-performance

From David Boreham
Subject Re: Hardware/OS recommendations for large databases (
Date
Msg-id 438BCB6D.3090406@boreham.org
Whole thread Raw
In response to Re: Hardware/OS recommendations for large databases (  (Brendan Duddridge <brendan@clickspace.com>)
List pgsql-performance
Brendan Duddridge wrote:

> Thanks for your reply. So how is that different than something like
> Slony2 or pgcluster with multi-master replication? Is it similar
> technology? We're currently looking for a good clustering solution
> that will work on our Apple Xserves and Xserve RAIDs.

I think you need to be more specific about what you're trying to do.
'clustering' encompasses so many things that it means almost nothing by
itself.

slony provides facilities for replicating data. Its primary purpose is
to improve reliability. MPP distributes both data and queries. Its
primary purpose is to improve performance for a subset of all query types.



pgsql-performance by date:

Previous
From: Brendan Duddridge
Date:
Subject: Re: Hardware/OS recommendations for large databases (
Next
From: David Lang
Date:
Subject: Re: Hardware/OS recommendations for large databases (