Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 459009FA5CE for ; Tue, 14 Nov 2006 20:14:12 -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 24501-01 for ; Wed, 15 Nov 2006 00:14:08 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from glacier.frostconsultingllc.com (glacier.frostconsultingllc.com [64.127.99.90]) by postgresql.org (Postfix) with ESMTP id 963779FA497 for ; Tue, 14 Nov 2006 20:14:08 -0400 (AST) Received: from adsl-69-226-255-19.dsl.pltn13.pacbell.net ([69.226.255.19]:47876 helo=discord.home.frostconsultingllc.com) by glacier.frostconsultingllc.com with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.63) (envelope-from ) id 1Gk8Pg-0001xx-Cg; Tue, 14 Nov 2006 16:14:07 -0800 Received: from localhost (localhost.localdomain [127.0.0.1]) by discord.home.frostconsultingllc.com (8.13.7/8.13.7) with ESMTP id kAF0DxCT031946; Tue, 14 Nov 2006 16:13:59 -0800 Date: Tue, 14 Nov 2006 16:13:59 -0800 (PST) From: Jeff Frost X-X-Sender: jeff@discord.home.frostconsultingllc.com To: Bruce Momjian cc: Chris Browne , pgsql-docs@postgresql.org In-Reply-To: <200611150011.kAF0Beb21787@momjian.us> Message-ID: References: <200611150011.kAF0Beb21787@momjian.us> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-SA-Exim-Connect-IP: 69.226.255.19 X-SA-Exim-Mail-From: jeff@glacier.frostconsultingllc.com Subject: Re: [HACKERS] Replication documentation addition X-SA-Exim-Version: 4.2 (built Tue, 02 May 2006 07:39:18 -0400) X-SA-Exim-Scanned: Yes (on glacier.frostconsultingllc.com) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.115 tagged_above=0 required=5 tests=BAYES_20, FORGED_RCVD_HELO, SARE_SPEC_REPLICA X-Spam-Level: X-Archive-Number: 200611/22 X-Sequence-Number: 3856 On Tue, 14 Nov 2006, Bruce Momjian wrote: >> "In clustering, each server can accept write requests, and these write >> requests are broadcast from the original server to all other servers before >> each transaction commits." >> >> Unfortunately, I can't seem to come up with anything more clever. > > 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. Ahh..I like this explanation, because the inter-server communication in clustering is not necessarily SQL queries. -- Jeff Frost, Owner Frost Consulting, LLC http://www.frostconsultingllc.com/ Phone: 650-780-7908 FAX: 650-649-1954