Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 868301337BBA for ; Mon, 7 Mar 2011 11:47:05 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 48733-06 for ; Mon, 7 Mar 2011 15:46:57 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from exprod7og110.obsmtp.com (exprod7og110.obsmtp.com [64.18.2.173]) by mail.postgresql.org (Postfix) with ESMTP id 6FE53133798E for ; Mon, 7 Mar 2011 11:46:54 -0400 (AST) Received: from source ([74.125.82.181]) (using TLSv1) by exprod7ob110.postini.com ([64.18.6.12]) with SMTP ID DSNKTXT97nxh5nPzg1HLeByj+7yE1LFz9090@postini.com; Mon, 07 Mar 2011 07:46:55 PST Received: by mail-wy0-f181.google.com with SMTP id 42so6565726wyb.40 for ; Mon, 07 Mar 2011 07:46:54 -0800 (PST) Received: by 10.216.168.67 with SMTP id j45mr2502845wel.101.1299512814106; Mon, 07 Mar 2011 07:46:54 -0800 (PST) Received: from [192.168.1.183] (dsl-hkibrasgw2-ff7ac300-240.dhcp.inet.fi [88.195.122.240]) by mx.google.com with ESMTPS id r57sm1333837wes.25.2011.03.07.07.46.52 (version=TLSv1/SSLv3 cipher=OTHER); Mon, 07 Mar 2011 07:46:53 -0800 (PST) Message-ID: <4D74FDEC.5040406@enterprisedb.com> Date: Mon, 07 Mar 2011 17:46:52 +0200 From: Heikki Linnakangas User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; fi-FI; rv:1.9.1.16) Gecko/20101226 Icedove/3.0.11 MIME-Version: 1.0 To: Andrew Dunstan CC: Aidan Van Dyk , Simon Riggs , pgsql-hackers@postgresql.org Subject: Re: Re: [COMMITTERS] pgsql: Efficient transaction-controlled synchronous replication. References: <4D741441.2090704@dunslane.net> <1299454125.1696.6138.camel@ebony> <4D74896C.5030402@enterprisedb.com> <4D74DDFA.70800@dunslane.net> <4D74E584.7080409@enterprisedb.com> <4D74E9FA.7070202@dunslane.net> <4D74F3AE.9000802@dunslane.net> In-Reply-To: <4D74F3AE.9000802@dunslane.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.419 tagged_above=-5 required=5 tests=BAYES_00=-1.9, FS_REPLICA=3.599, SARE_SPEC_REPLICA=0.72 X-Spam-Level: ** X-Archive-Number: 201103/472 X-Sequence-Number: 183722 On 07.03.2011 17:03, Andrew Dunstan wrote: > This is about expectations. The thing that worries me is that the use of > this term might cause some people NOT to use 2PC because they think they > are getting an equivalent guarantee, when in fact they are not. And > that's hardly unreasonable. Here for example is what wikipedia says > : > > Synchronous replication - guarantees "zero data loss" by the means > of atomic write operation, i.e. write either completes on both sides > or not at all. Write is not considered complete until > acknowledgement by both local and remote storage. Hmm, I've read that wikipedia definition before, but the "atomic" part never caught my eye. You do get zero data loss with what we have; if a meteor strikes the master, no acknowledged transaction is lost. I find that definition a bit confusing. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com