X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id B097A9DCC39 for ; Mon, 28 Nov 2005 23:30:54 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 01674-06 for ; Mon, 28 Nov 2005 23:30:57 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from toad.mtbrook.bozemanpass.com (toad.mtbrook.bozemanpass.com [69.145.82.195]) by postgresql.org (Postfix) with ESMTP id E1C5B9DCC19 for ; Mon, 28 Nov 2005 23:30:50 -0400 (AST) Received: from [69.145.82.253] (unknown [69.145.82.253]) by toad.mtbrook.bozemanpass.com (Postfix) with ESMTP id 2E69B1102E6 for ; Mon, 28 Nov 2005 19:30:52 -0800 (PST) Message-ID: <438BCB6D.3090406@boreham.org> Date: Mon, 28 Nov 2005 20:30:53 -0700 From: David Boreham User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: Re: Hardware/OS recommendations for large databases ( References: <179B5137-F0BB-4037-A5AD-3459B914E580@clickspace.com> <3017A204-1BAF-4E62-ADA6-695E34557645@clickspace.com> In-Reply-To: <3017A204-1BAF-4E62-ADA6-695E34557645@clickspace.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[AWL=0.000] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/547 X-Sequence-Number: 15804 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.