Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 73DAB9F99FC for ; Wed, 19 Sep 2007 16:02:38 -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 13909-02 for ; Wed, 19 Sep 2007 16:02:16 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from oxford.xeocode.com (unknown [87.127.95.196]) by postgresql.org (Postfix) with ESMTP id 047F69F99DE for ; Wed, 19 Sep 2007 16:02:18 -0300 (ADT) Received: from localhost ([127.0.0.1] helo=oxford.xeocode.com) by oxford.xeocode.com with esmtp (Exim 4.67) (envelope-from ) id 1IY4oM-0001XJ-HT; Wed, 19 Sep 2007 20:02:10 +0100 To: "Tom Lane" Cc: "Andrew Dunstan" , "Stefan Kaltenbrunner" , Subject: Re: curious regression failures In-Reply-To: <22220.1190219640@sss.pgh.pa.us> (Tom Lane's message of "Wed\, 19 Sep 2007 12\:34\:00 -0400") User-Agent: Gnus/5.11 (Gnus v5.11) Emacs/22.1 (gnu/linux) X-Draft-From: ("nnimap+mail01.enterprisedb.com:INBOX.hackers" 13659) References: <200709141720.l8EHKwX13792@momjian.us> <87bqc5m90n.fsf@oxford.xeocode.com> <12919.1189792669@sss.pgh.pa.us> <46EADA0A.3040504@kaltenbrunner.cc> <12435.1189821208@sss.pgh.pa.us> <46EC07E7.9000100@kaltenbrunner.cc> <28630.1189875785@sss.pgh.pa.us> <46ED527A.4090108@kaltenbrunner.cc> <20616.1190214860@sss.pgh.pa.us> <46F1468F.1080903@dunslane.net> <22220.1190219640@sss.pgh.pa.us> From: Gregory Stark Organization: EnterpriseDB Date: Wed, 19 Sep 2007 20:02:09 +0100 Message-ID: <87r6kuh426.fsf@oxford.xeocode.com> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="=security-NASA-cybercash-Abu-Ghraib-warfare-Rand-Corporation-Bellcore" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/801 X-Sequence-Number: 107953 --=security-NASA-cybercash-Abu-Ghraib-warfare-Rand-Corporation-Bellcore Looking back, by far the largest change in the period Sep 1 - Sep 11 was the lazy xid calculation and read-only transactions. That seems like the most likely culprit. But given Tom's comments this commit stands out too: --=security-NASA-cybercash-Abu-Ghraib-warfare-Rand-Corporation-Bellcore Content-Type: message/rfc822 Content-Disposition: inline thread-index: Acfz86Z0PDqZxsbIQPqNhWQWdDbTjg== Received: from mailGateway.enterprisedb.com ([192.168.10.179]) by mail01.enterprisedb.com with Microsoft SMTPSVC(6.0.3790.3959); Mon, 10 Sep 2007 17:43:39 -0400 X-ASG-Debug-ID: 1189460604-648f001f0000-ruEZGk X-Barracuda-URL: http://spam.enterprisedb.com:8000/cgi-bin/mark.cgi Content-Class: urn:content-classes:message Importance: normal Priority: normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.4073 X-Barracuda-Connect: postgresql.org[200.46.204.71] X-Barracuda-Start-Time: 1189460604 Received: from postgresql.org (postgresql.org [200.46.204.71]) by mailGateway.enterprisedb.com (Spam Firewall) with ESMTP id A55A21AFF2 for ; Mon, 10 Sep 2007 17:43:24 -0400 (EDT) Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 97C9C9FA000; Mon, 10 Sep 2007 18:43:24 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 76184-08; Mon, 10 Sep 2007 18:43:24 -0300 (ADT) Received: from postgresql.org (postgresql.org [200.46.204.71]) by postgresql.org (Postfix) with ESMTP id 2A9409F9DFA; Mon, 10 Sep 2007 18:43:24 -0300 (ADT) Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 6F6AF9F97B5 for ; Mon, 10 Sep 2007 18:40:12 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 38727-05 for ; Mon, 10 Sep 2007 18:40:04 -0300 (ADT) Received: from cvs.postgresql.org (cvs.postgresql.org [217.196.146.206]) by postgresql.org (Postfix) with ESMTP id B389B9F9DFA for ; Mon, 10 Sep 2007 18:40:04 -0300 (ADT) Received: by cvs.postgresql.org (Postfix, from userid 1193) id 67EED754206; Mon, 10 Sep 2007 21:40:03 +0000 (UTC) To: X-ASG-Orig-Subj: pgsql: Release the exclusive lock on the table early after truncating it Subject: pgsql: Release the exclusive lock on the table early after truncating it X-Mailer: activitymail 1.24, http://search.cpan.org/dist/activitymail/ Message-ID: <20070910214003.67EED754206@cvs.postgresql.org> Date: Mon, 10 Sep 2007 21:40:03 +0000 (UTC) From: "Alvaro Herrera" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Mailing-List: pgsql-committers List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: Precedence: bulk Sender: X-Barracuda-Virus-Scanned: by Barracuda Spam Firewall at enterprisedb.com X-Barracuda-Spam-Score: 0.10 X-Barracuda-Spam-Status: No, SCORE=0.10 using global scores of TAG_LEVEL=3.0 QUARANTINE_LEVEL=3.5 KILL_LEVEL=5.0 tests=BSF_SC0_SA085 X-Barracuda-Spam-Report: Code version 3.1, rules version 3.1.28069Rule breakdown below pts rule name description---- ---------------------- --------------------------------------------------0.10 BSF_SC0_SA085 URI: Custom Rule SA085 Return-Path: X-OriginalArrivalTime: 10 Sep 2007 21:43:39.0750 (UTC) FILETIME=[A663A860:01C7F3F3] MIME-Version: 1.0 Log Message: ----------- Release the exclusive lock on the table early after truncating it in lazy vacuum, instead of waiting till commit. Modified Files: -------------- pgsql/src/backend/commands: vacuumlazy.c (r1.92 -> r1.93) (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/vacuumlazy.c?r1=1.92&r2=1.93) ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly --=security-NASA-cybercash-Abu-Ghraib-warfare-Rand-Corporation-Bellcore -- Gregory Stark EnterpriseDB http://www.enterprisedb.com --=security-NASA-cybercash-Abu-Ghraib-warfare-Rand-Corporation-Bellcore--