Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id B5ADD9FA12B; Fri, 1 Dec 2006 15:16:38 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 65136-06; Fri, 1 Dec 2006 15:16:30 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from momjian.us (momjian.us [70.90.9.53]) by postgresql.org (Postfix) with ESMTP id 82EF69F9F0E; Fri, 1 Dec 2006 15:16:29 -0400 (AST) Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id kB1JGRx16905; Fri, 1 Dec 2006 14:16:27 -0500 (EST) From: Bruce Momjian Message-Id: <200612011916.kB1JGRx16905@momjian.us> Subject: Re: [CORE] FOR SHARE vs FOR UPDATE locks In-Reply-To: <200612011055.06368.josh@agliodbs.com> To: josh@agliodbs.com Date: Fri, 1 Dec 2006 14:16:27 -0500 (EST) CC: pgsql-core@postgresql.org, Tom Lane , Heikki Linnakangas , Alvaro Herrera , Simon Riggs , pgsql-hackers@postgresql.org X-Mailer: ELM [version 2.4ME+ PL123] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="US-ASCII" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/38 X-Sequence-Number: 94519 Josh Berkus wrote: > Tom, > > > So at this point we are facing three options: > > ????????- throw in a large and poorly tested "fix" at the last moment; > > ????????- postpone 8.2 until we can think of a real fix, which might > > ???????? ?be a major undertaking; > > ????????- ship 8.2 with the same behavior 8.0 and 8.1 had. > > None of these are very attractive, but I'm starting to think the last > > is the least bad. > > Yes. If it was earlier in the beta cycle I'd say no, but frankly this > behavior has existed for two years without examples of real-life data > loss. Further, the TPC tests, which are supposed to give ACID properties > a workout, would not break this, so the industry doesn't consider it very > important either. > > So, I think it needs to go on the list for 8.2.1 or 8.3 (depending on what > changes the fix requires) but I don't think we should hold up the release. We cannot add something this major in a minor release --- it would have to be 8.3. -- Bruce Momjian bruce@momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +