Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id B3BF2B5DC03 for ; Thu, 7 Jul 2011 18:33:40 -0300 (ADT) 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 19291-08 for ; Thu, 7 Jul 2011 21:33:34 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from exprod7og121.obsmtp.com (exprod7og121.obsmtp.com [64.18.2.20]) by mail.postgresql.org (Postfix) with ESMTP id DC7A4B5DBF0 for ; Thu, 7 Jul 2011 18:33:33 -0300 (ADT) Received: from mail-fx0-f41.google.com ([209.85.161.41]) (using TLSv1) by exprod7ob121.postini.com ([64.18.6.12]) with SMTP ID DSNKThYmLZu/k7UFE/F5Dgn3lalBfZpAs4sp@postini.com; Thu, 07 Jul 2011 14:33:34 PDT Received: by fxg9 with SMTP id 9so1521783fxg.14 for ; Thu, 07 Jul 2011 14:33:32 -0700 (PDT) Received: by 10.223.58.147 with SMTP id g19mr1043914fah.72.1310074411808; Thu, 07 Jul 2011 14:33:31 -0700 (PDT) Received: from [90.190.247.247] (247.247.190.90.dyn.estpak.ee [90.190.247.247]) by mx.google.com with ESMTPS id k17sm1113084fah.37.2011.07.07.14.33.29 (version=TLSv1/SSLv3 cipher=OTHER); Thu, 07 Jul 2011 14:33:30 -0700 (PDT) Message-ID: <4E162628.6080100@enterprisedb.com> Date: Fri, 08 Jul 2011 00:33:28 +0300 From: Heikki Linnakangas User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; fi-FI; rv:1.9.2.17) Gecko/20110606 Icedove/3.1.10 MIME-Version: 1.0 To: Dan Ports CC: Kevin Grittner , pgsql-hackers@postgresql.org Subject: Re: SSI atomic commit References: <4E12FDA8020000250003EFC1@gw.wicourts.gov> <4E15D48A.7080203@enterprisedb.com> <4E159B5C020000250003F063@gw.wicourts.gov> <4E160005.1020300@enterprisedb.com> <4E161881.6090800@enterprisedb.com> <20110707212159.GF76634@csail.mit.edu> In-Reply-To: <20110707212159.GF76634@csail.mit.edu> 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=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201107/358 X-Sequence-Number: 191457 On 08.07.2011 00:21, Dan Ports wrote: > We should also apply the attached patch, which corrects a minor issue > with the conditions for flagging transactions that could potentially > make a snapshot unsafe. > > There's a small window wherein a transaction is committed but not yet > on the finished list, and we shouldn't flag it as a potential conflict > if so. We can also skip adding a doomed transaction to the list of > possible conflicts because we know it won't commit. Hmm, it's now also possible for the transaction to be prepared, and already visible to others, but not yet flagged as committed. Shouldn't those be included too? -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com