Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 54A5AB5DBEC for ; Wed, 29 Jun 2011 16:19:24 -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 43014-01 for ; Wed, 29 Jun 2011 19:19:18 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from exprod7og101.obsmtp.com (exprod7og101.obsmtp.com [64.18.2.155]) by mail.postgresql.org (Postfix) with ESMTP id 62FCAB5DBE9 for ; Wed, 29 Jun 2011 16:19:17 -0300 (ADT) Received: from mail-fx0-f52.google.com ([209.85.161.52]) (using TLSv1) by exprod7ob101.postini.com ([64.18.6.12]) with SMTP ID DSNKTgt6tI5/OyeE0T8nx6yas2KErrq5VjdQ@postini.com; Wed, 29 Jun 2011 12:19:17 PDT Received: by fxd18 with SMTP id 18so1507035fxd.11 for ; Wed, 29 Jun 2011 12:19:15 -0700 (PDT) Received: by 10.223.14.11 with SMTP id e11mr1675437faa.131.1309375155152; Wed, 29 Jun 2011 12:19:15 -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 j23sm1067202fai.15.2011.06.29.12.19.12 (version=TLSv1/SSLv3 cipher=OTHER); Wed, 29 Jun 2011 12:19:13 -0700 (PDT) Message-ID: <4E0B7AAF.10903@enterprisedb.com> Date: Wed, 29 Jun 2011 22:19:11 +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: Kevin Grittner CC: drkp@csail.mit.edu, pgsql-hackers@postgresql.org Subject: Re: Repeated PredicateLockRelation calls during seqscan References: <4E07550F020000250003EC42@gw.wicourts.gov> In-Reply-To: <4E07550F020000250003EC42@gw.wicourts.gov> 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: 201106/2271 X-Sequence-Number: 190984 On 26.06.2011 23:49, Kevin Grittner wrote: > "Kevin Grittner" wrote: >> "Kevin Grittner" wrote: >>> Heikki Linnakangas wrote: > >>>> BTW, isn't bitgetpage() in nodeBitmapHeapscan.c missing >>>> PredicateLockTuple() and CheckForSerializableConflictOut() calls >>>> in the codepath for a lossy bitmap? In the non-lossy case, >>>> heap_hot_search_buffer() takes care of it, but not in the lossy >>>> case. >>> >>> I think the attached addresses that. >> >> Don't commit that patch, it's not holding up in testing here. >> >> I'll look at it some more. > > Version 2 is attached. Thanks, applied this too. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com