Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 9C5031337BAE for ; Tue, 4 Jan 2011 14:29:02 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 19922-02-3 for ; Tue, 4 Jan 2011 18:28:55 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail148138.authsmtp.net (outmail148138.authsmtp.net [62.13.148.138]) by mail.postgresql.org (Postfix) with ESMTP id 5CB401337BC5 for ; Tue, 4 Jan 2011 14:28:51 -0400 (AST) Received: from mail-c193.authsmtp.com (mail-c193.authsmtp.com [62.13.128.118]) by punt3.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id p04ISfEj099700; Tue, 4 Jan 2011 18:28:41 GMT Received: from Sidney-Stratton.local (dsl081-245-111.sfo1.dsl.speakeasy.net [64.81.245.111]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2) with ESMTP id p04ISVWp059876; Tue, 4 Jan 2011 18:28:32 GMT Message-ID: <4D2366CE.1010705@agliodbs.com> Date: Tue, 04 Jan 2011 10:28:30 -0800 From: Josh Berkus User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9.1b3pre) Gecko/20090223 Thunderbird/3.0b2 MIME-Version: 1.0 To: Simon Riggs CC: Heikki Linnakangas , Robert Haas , Hannu Krosing , greg@2ndquadrant.com, Stefan Kaltenbrunner , pgsql-hackers@postgresql.org Subject: Re: Sync Rep Design References: <1293729972.1892.23804.camel@ebony> <4D1CC47E.7050207@kaltenbrunner.cc> <1293735853.1892.24886.camel@ebony> <4D1D8B2F.5070001@2ndquadrant.com> <4D1DAB14.5000800@enterprisedb.com> <1293796137.1892.37313.camel@ebony> <4D1DCF5A.7070808@enterprisedb.com> <4D1E4897.1050400@2ndquadrant.com> <1293882875.1892.56143.camel@ebony> <1293975673.2090.464.camel@ebony> <4D20ADC5.7070804@enterprisedb.com> <1294003186.2090.3338.camel@ebony> In-Reply-To: <1294003186.2090.3338.camel@ebony> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit X-Server-Quench: 7044de4e-1830-11e0-97bb-002264978518 X-AuthReport-Spam: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-AuthRoute: OCdyZgscClZXSx8a IioLCC5HRQ8+YBZL BAkGMA9GIUINWEQO c1ACch1xOVtbHwkA AnYKU15WWFdyXS1z bxRZbBtfZk9QXgRr T0pMQFdNFEsoARh4 ZXh5Ehl3fg1BfjBx Y0drXz5cXEB+IRN5 F1NVHW4GeGZhPWAC WUcKJR5UcAFIeBtM bVh6VXtDAzANdhEY NiQQEgoKCH1kOSJe CjsANRo+TF0KEThU X-Authentic-SMTP: 61633136333939.1014:706 X-AuthFastPath: 255 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201101/259 X-Sequence-Number: 178096 All, This is a pointless argument. Eventually, we will be implementing all possible sync rep configurations, because different users *need* different configurations. Some users care more about durability, some more about availability, and some more about response time. And you can't have all three, which was my point about A,D,R (also the point of CAP). For that matter, any single configuration will be useful to a large number of users, and an even larger number will be able to "work around" while they wait for 9.2. Further, the knowledge we gain by having some kind of synch rep in the field will allow us to implement the different configurations correctly, which *no* amount of arguing on e-mail will. The perfect is the enemy of the good. The relevant question is: which configuration(s) can we have ready for the next CommitFest and alpha release? -- -- Josh Berkus PostgreSQL Experts Inc. http://www.pgexperts.com