Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id B28522E0069 for ; Fri, 28 Mar 2008 02:56:03 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 89502-10 for ; Fri, 28 Mar 2008 02:55:58 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 4C7432E004D for ; Fri, 28 Mar 2008 02:55:57 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m2S5tumq025150; Fri, 28 Mar 2008 01:55:56 -0400 (EDT) To: Robert Treat cc: pgsql-hackers@postgresql.org Subject: Re: [COMMITTERS] pgsql: Fix TransactionIdIsCurrentTransactionId() to use binary search In-reply-to: <200803280151.54874.xzilla@users.sourceforge.net> References: <20080317021856.0D2D37558DC@cvs.postgresql.org> <200803271656.45574.xzilla@users.sourceforge.net> <2092.1206652297@sss.pgh.pa.us> <200803280151.54874.xzilla@users.sourceforge.net> Comments: In-reply-to Robert Treat message dated "Fri, 28 Mar 2008 01:51:54 -0400" Date: Fri, 28 Mar 2008 01:55:56 -0400 Message-ID: <25149.1206683756@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/1152 X-Sequence-Number: 115953 Robert Treat writes: >> If you can convince me it's a regression I might reconsider, but I >> rather doubt that 8.2 was better, > Well, I can't speak for 8.2, but I have a second system crunching the same > data using the same function on 8.1 (on lesser hardware in fact), and it > doesn't have these type of issues. If you can condense it to a test case that is worse on 8.3 than 8.1, I'm willing to listen... regards, tom lane