Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id D31399F9ECC for ; Sat, 18 Nov 2006 19:29:06 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 01458-05-2 for ; Sat, 18 Nov 2006 23:29:00 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from davinci.ethosmedia.com (server227.ethosmedia.com [209.128.84.227]) by postgresql.org (Postfix) with ESMTP id 5C3069F946B for ; Sat, 18 Nov 2006 19:29:00 -0400 (AST) X-EthosMedia-Virus-Scanned: no infections found Received: from [63.195.55.98] (account josh@agliodbs.com HELO spooky.sf.agliodbs.com) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.1.8) with ESMTP id 10641822; Sat, 18 Nov 2006 15:32:40 -0800 From: Josh Berkus Organization: PostgreSQL @ Sun To: pgsql-docs@postgresql.org Subject: Re: [HACKERS] Replication documentation addition Date: Sat, 18 Nov 2006 15:29:07 -0800 User-Agent: KMail/1.8.2 Cc: Jim Nasby , Bruce Momjian , Jeff Frost , Chris Browne References: <200611150011.kAF0Beb21787@momjian.us> In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200611181529.07429.josh@agliodbs.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/33 X-Sequence-Number: 3867 Jim, > That's true of simple query broadcasting (ie: pgpool), but not true =A0 > of Continuent/Sequoia. Continuent's software adds a lot of additional =A0 > features on top of simple query broadcasting, making it far more =A0 > robust than simply spewing queries out to every node in the cluster. =A0 > You still have to be very careful with how you use it, but not nearly =A0 > as much as with simpler solutions. I think the general term is "statement-based replication", not "broadcastin= g". =2D-=20 Josh Berkus PostgreSQL @ Sun San Francisco