Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id C6CB9632FE5 for ; Mon, 8 Feb 2010 16:01:22 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 58920-08 for ; Mon, 8 Feb 2010 20:00:42 +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 SMTP id 6742E632AEC for ; Mon, 8 Feb 2010 16:01:11 -0400 (AST) Received: from source ([74.125.78.25]) by exprod7ob121.postini.com ([64.18.6.12]) with SMTP ID DSNKS3BthW/25tof5MXXe/g7Z7hfwJKuCrvk@postini.com; Mon, 08 Feb 2010 12:01:11 PST Received: by ey-out-2122.google.com with SMTP id 9so1249813eyd.27 for ; Mon, 08 Feb 2010 12:01:08 -0800 (PST) Received: by 10.213.1.19 with SMTP id 19mr5865694ebd.21.1265659268131; Mon, 08 Feb 2010 12:01:08 -0800 (PST) Received: from ?192.168.1.117? ([88.195.103.165]) by mx.google.com with ESMTPS id 10sm12456384eyd.13.2010.02.08.12.01.06 (version=TLSv1/SSLv3 cipher=RC4-MD5); Mon, 08 Feb 2010 12:01:07 -0800 (PST) Message-ID: <4B706D81.7010600@enterprisedb.com> Date: Mon, 08 Feb 2010 22:01:05 +0200 From: Heikki Linnakangas Organization: EnterpriseDB User-Agent: Mozilla-Thunderbird 2.0.0.22 (X11/20090706) MIME-Version: 1.0 To: Alvaro Herrera CC: Tom Lane , pgsql-hackers@postgreSQL.org Subject: Re: Order of operations in lazy_vacuum_rel References: <13481.1265650179@sss.pgh.pa.us> <20100208173855.GN4113@alvh.no-ip.org> <13824.1265651227@sss.pgh.pa.us> <20100208191917.GO4113@alvh.no-ip.org> In-Reply-To: <20100208191917.GO4113@alvh.no-ip.org> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.391 tagged_above=-10 required=5 tests=AWL=0.208, BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201002/548 X-Sequence-Number: 156891 Alvaro Herrera wrote: > Tom Lane wrote: >> The point would be to not disable interrupts till after doing the FSM >> vacuuming. Ignoring CANCEL for longer than we must is bad. > > Oh, I see. I guess the answer is that it depends on what happens if you > interrupt after vacuuming the FSM. I have no idea what that is supposed > to accomplish so I'm of no help here. FreeSpaceMapVacuum says it's > about fixing inconsistencies in the FSM, so I'm guessing that it's not > critical. Yeah, interrupting FreeSpaceMapVacuum (or right after it) is harmless. > FWIW I notice that RelationTruncate contains an outdated comment at the > top about the 'fsm' function argument which is nowadays no longer an > argument. Thanks, fixed. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com