Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id A80969FB26E
	for <pgsql-docs-postgresql.org@postgresql.org>;
	Tue, 14 Nov 2006 18:32:44 -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 51029-05 for <pgsql-docs-postgresql.org@postgresql.org>;
	Tue, 14 Nov 2006 18:32:39 -0400 (AST)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from momjian.us (momjian.us [70.90.9.53])
	by postgresql.org (Postfix) with ESMTP id 56F599FB29C
	for <pgsql-docs@postgresql.org>; Tue, 14 Nov 2006 18:32:38 -0400 (AST)
Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id
 kAEMWL901054;
	Tue, 14 Nov 2006 17:32:21 -0500 (EST)
From: Bruce Momjian <bruce@momjian.us>
Message-Id: <200611142232.kAEMWL901054@momjian.us>
Subject: Re: [HACKERS] Replication documentation addition
In-Reply-To: 
 <Pine.LNX.4.64.0611141417310.23695@discord.home.frostconsultingllc.com>
To: Jeff Frost <jeff@frostconsultingllc.com>
Date: Tue, 14 Nov 2006 17:32:21 -0500 (EST)
CC: Chris Browne <cbbrowne@acm.org>, pgsql-docs@postgresql.org
X-Mailer: ELM [version 2.4ME+ PL123]
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset="US-ASCII"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200611/15
X-Sequence-Number: 3849

Jeff Frost wrote:
> >>>  <para>
> >>>   Clustering is implemented by <productname>Oracle</> in their
> >>>   <productname><acronym>RAC</></> product.  <productname>PostgreSQL</>
> >>>   does not offer this type of load balancing, though
> >>>   <productname>PostgreSQL</> two-phase commit (<xref
> >>>   linkend="sql-prepare-transaction-title"> and <xref linkend=
> >>>   "sql-commit-prepared-title">) can be used to implement this in
> >>>   application code or middleware.
> >>>  </para>
> >>
> >> Bruce,
> >>
> >> Continuent's uni/cluster middleware product implements this type of
> >> clustering/load balancing.  Perhaps it warrants a mention?  Not sure how far
> >> we want to get into listing external products.
> >
> > We had a long discussion about that and felt that recommending
> > commercial products or even every open source project was too much.  The
> > idea was that we should reference a web page that has them all mentioned,
> > but no one has set one up yet.
> 
> That makes sense, I just hate to see us say something like "Oracle can do 
> this with RAC but PostgreSQL cannot."

Agreed.  I think we would mention any PostgreSQL solution for this, even
if it is not open source.  We mention solutions as examples in this part
of the documentation.

FYI, as far as I know, Continuent's solution is "Query Broadcast Load
Balancing", not clustering.

-- 
  Bruce Momjian   bruce@momjian.us
  EnterpriseDB    http://www.enterprisedb.com

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