public inbox for [email protected]  

help / color / mirror / Atom feed

From: Bruce Momjian <[email protected]>
To: Markus Schiltknecht <[email protected]>
Cc: Peter Eisentraut <[email protected]>
Cc: [email protected]
Subject: Re: "Clustering"
Date: Tue, 21 Nov 2006 23:04:48 -0500 (EST)
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>

Markus Schiltknecht wrote:
> 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.

Uh, multi-master replication allows for load balancing, but it doesn't
help a single query to run any faster.  Think of having only one query
running on the cluster.  Parallel execution allows a single query to use
more than one computer, right?

> 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.

Uh, this confuses me.  What is missing?  You split tables across
multiple servers.

-- 
  Bruce Momjian   [email protected]
  EnterpriseDB    http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

view thread (6+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: "Clustering"
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox