Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 4B7149F9CF9 for ; Fri, 17 Nov 2006 01:59:37 -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 13235-03 for ; Fri, 17 Nov 2006 05:59:31 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from noel.decibel.org (noel.decibel.org [67.100.216.10]) by postgresql.org (Postfix) with ESMTP id 6CD379F9F77 for ; Fri, 17 Nov 2006 01:59:31 -0400 (AST) Received: from [192.168.42.113] (natpool.bovine.net [67.100.216.14]) (using TLSv1 with cipher AES128-SHA (128/128 bits)) (No client certificate requested) by noel.decibel.org (Postfix) with ESMTP id 4DF455643A; Thu, 16 Nov 2006 23:59:30 -0600 (CST) In-Reply-To: <200611150011.kAF0Beb21787@momjian.us> References: <200611150011.kAF0Beb21787@momjian.us> Mime-Version: 1.0 (Apple Message framework v752.2) Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Message-Id: Cc: Jeff Frost , Chris Browne , pgsql-docs@postgresql.org Content-Transfer-Encoding: 7bit From: Jim Nasby Subject: Re: [HACKERS] Replication documentation addition Date: Thu, 16 Nov 2006 18:48:58 -0700 To: Bruce Momjian X-Mailer: Apple Mail (2.752.2) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/32 X-Sequence-Number: 3866 On Nov 14, 2006, at 5:11 PM, Bruce Momjian wrote: > Basically, when you are broadcasting outside the server, you are > broadcasting SQL queries, and those queries do not have information > about non-deterministic functions and have issues with universal > commits > on all node. That's true of simple query broadcasting (ie: pgpool), but not true of Continuent/Sequoia. Continuent's software adds a lot of additional features on top of simple query broadcasting, making it far more robust than simply spewing queries out to every node in the cluster. You still have to be very careful with how you use it, but not nearly as much as with simpler solutions. -- Jim Nasby jim@nasby.net EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)