Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 6DEA59FA2B9 for ; Tue, 21 Nov 2006 11:50:16 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 70470-06 for ; Tue, 21 Nov 2006 11:50:11 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from bugaboo.mu (ns1.bugaboo.mu [213.133.111.57]) by postgresql.org (Postfix) with ESMTP id 2A8219FA333 for ; Tue, 21 Nov 2006 11:50:10 -0400 (AST) Received: from [192.168.77.20] (p54BD8740.dip0.t-ipconnect.de [::ffff:84.189.135.64]) (AUTH: CRAM-MD5 markus@bluegap.ch) by bugaboo.mu with esmtp; Tue, 21 Nov 2006 16:50:07 +0100 id 02229B0C.45632030.000013C3 Message-ID: <4563202E.3090403@bluegap.ch> Date: Tue, 21 Nov 2006 16:50:06 +0100 From: Markus Schiltknecht User-Agent: Icedove 1.5.0.8 (X11/20061116) MIME-Version: 1.0 CC: Bruce Momjian , Peter Eisentraut , pgsql-docs@postgresql.org Subject: Re: "Clustering" References: <200611202218.kAKMITh16596@momjian.us> <4562C9F3.9020300@bluegap.ch> In-Reply-To: <4562C9F3.9020300@bluegap.ch> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/58 X-Sequence-Number: 3892 Hi, I wrote: > That reminds me of the requirement of having Multi Master Replication in > place to do Parallel Query Execution. Sync Multi Master Replication > being better, while Async Multi Master Replication obviously leads to > inconsistent responses, when queried in parallel. That may be acceptable > in certain situations. Oops, during rereading "Clustering For Parallel Query Execution", I've noticed that you mention Data Partitioning as one possible way to do Parallel Query Execution. Thus Multi Master Replication obviously is not a requirement, but just another way to allow for Parallel Query Execution. Mentioning that as well would probably be good. IMHO, the advice to use multiple, independent databases to do parallel query execution sounds a little meager. Of course it's also parallel query execution, but it's not what most people suspect to find under that section, I would guess. Regards Markus