X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id DB20E56458 for ; Wed, 9 Mar 2005 12:30:10 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 95332-08 for ; Wed, 9 Mar 2005 12:30:02 +0000 (GMT) Received: from anchor-post-32.mail.demon.net (anchor-post-32.mail.demon.net [194.217.242.90]) by svr1.postgresql.org (Postfix) with ESMTP id 1448B5645A for ; Wed, 9 Mar 2005 12:30:01 +0000 (GMT) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-32.mail.demon.net with esmtp (Exim 4.42) id 1D90KB-000LBf-8r; Wed, 09 Mar 2005 12:30:04 +0000 Received: from [192.168.1.17] (client17.archonet.com [192.168.1.17]) by mainbox.archonet.com (Postfix) with ESMTP id ADDF1176A3; Wed, 9 Mar 2005 12:30:02 +0000 (GMT) Message-ID: <422EEC49.7080202@archonet.com> Date: Wed, 09 Mar 2005 12:30:01 +0000 From: Richard Huxton User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Gaetano Mendola Cc: Michael Fuhr , "pgsql-performance@postgresql.org" Subject: Re: vacuum full, why multiple times ? References: <422E4B15.60806@bigfoot.com> <20050309021533.GB13883@winnie.fuhr.org> <422EDDA2.5000901@bigfoot.com> In-Reply-To: <422EDDA2.5000901@bigfoot.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.063 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200503/164 X-Sequence-Number: 10869 Gaetano Mendola wrote: > > # vacuum full verbose url; > INFO: vacuuming "public.url" > INFO: "url": found 74 removable, 21266 nonremovable row versions in 8550 pages > DETAIL: 2 dead row versions cannot be removed yet. > [SNIP] > INFO: "url": moved 11 row versions, truncated 8550 to 8504 pages > > > and in the next run: > > > # vacuum full verbose url; > INFO: vacuuming "public.url" > INFO: "url": found 13 removable, 21264 nonremovable row versions in 8504 pages > DETAIL: 0 dead row versions cannot be removed yet. > [SNIP] > INFO: "url": moved 5666 row versions, truncated 8504 to 621 pages If page number 8549 was the one being held, I don't think vacuum can truncate the file. The empty space can be re-used, but the rows can't be moved to a lower page while a transaction is using them. -- Richard Huxton Archonet Ltd