Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id B71C1B5DBE9 for ; Thu, 7 Jul 2011 18:35:35 -0300 (ADT) 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 62857-01 for ; Thu, 7 Jul 2011 21:35:29 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from exprod7og112.obsmtp.com (exprod7og112.obsmtp.com [64.18.2.177]) by mail.postgresql.org (Postfix) with ESMTP id DB348B5D803 for ; Thu, 7 Jul 2011 18:35:28 -0300 (ADT) Received: from mail-fx0-f41.google.com ([209.85.161.41]) (using TLSv1) by exprod7ob112.postini.com ([64.18.6.12]) with SMTP ID DSNKThYmoDCYd4w/1MM7o9xIrplTjq9F8Jtx@postini.com; Thu, 07 Jul 2011 14:35:29 PDT Received: by mail-fx0-f41.google.com with SMTP id 9so1435949fxg.28 for ; Thu, 07 Jul 2011 14:35:28 -0700 (PDT) Received: by 10.223.145.144 with SMTP id d16mr1895927fav.100.1310074528068; Thu, 07 Jul 2011 14:35:28 -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 l26sm6958215fah.14.2011.07.07.14.35.26 (version=TLSv1/SSLv3 cipher=OTHER); Thu, 07 Jul 2011 14:35:27 -0700 (PDT) Message-ID: <4E16269C.1000503@enterprisedb.com> Date: Fri, 08 Jul 2011 00:35:24 +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 CC: Dan Ports , 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> <4E162628.6080100@enterprisedb.com> In-Reply-To: <4E162628.6080100@enterprisedb.com> 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=-0.879 tagged_above=-5 required=5 tests=BAYES_00=-1.9, MISSING_HEADERS=1.021 X-Spam-Level: X-Archive-Number: 201107/360 X-Sequence-Number: 191459 On 08.07.2011 00:33, Heikki Linnakangas wrote: > 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? Oh, never mind, I read the test backwards. They are included, as the patch stands. I'll commit this too.. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com