public inbox for [email protected]  

help / color / mirror / Atom feed

From: Bruce Momjian <[email protected]>
To: Markus Schiltknecht <[email protected]>
Cc: Emmanuel Cecchet <[email protected]>
Cc: [email protected]
Cc: Sequoia general mailing list <[email protected]>
Subject: Re: [Sequoia] PostgreSQL Documentation of High Availability
Date: Wed, 22 Nov 2006 13:11:15 -0500 (EST)
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>

Markus Schiltknecht wrote:
> Hello Emmanuel,
> 
> Emmanuel Cecchet wrote:
> >>> Even here I think that there is a common misconception between 
> >>> performance and scalability. Most people think that by having 
> >>> multiple nodes their query will run faster which is obviously wrong 
> >>> if your original workload does not saturate a single node. 
> >>
> >> Sure. Do you think that should be made clearer?
> > Yes, I think so because this is a very common belief that we experience 
> > with new users.
> 
> Okay, I have forwarded that to Bruce, who's editing the documentation 
> (and is a native English speaker). I'm not sure how we can cover this, 
> as we are very general in our description.

OK, updated:

  <term>Multi-Server Parallel Query Execution</term>
  <listitem>

   <para>
    Many of the above solutions allow multiple servers to handle
    multiple queries, but none allow a single query to use multiple
    servers to complete faster.  This solution allows multiple
    servers to work concurrently on a single query.  This is usually
    accomplished by splitting the data among servers and having
    each server execute its part of the query and return results
    to a central server where they are combined and returned to
    the user.  Pgpool-II has this capability.

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

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

view thread (25+ messages)  latest in thread

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], [email protected]
  Subject: Re: [Sequoia] PostgreSQL Documentation of High Availability
  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