X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id CC7D39DCAAE for ; Thu, 19 Jan 2006 19:10:42 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 31064-08 for ; Thu, 19 Jan 2006 19:10:44 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from linda-3.paradise.net.nz (bm-3a.paradise.net.nz [203.96.152.182]) by postgresql.org (Postfix) with ESMTP id 41AEA9DC9E6 for ; Thu, 19 Jan 2006 19:10:39 -0400 (AST) Received: from smtp-3.paradise.net.nz (tclsnelb1-src-1.paradise.net.nz [203.96.152.172]) by linda-3.paradise.net.nz (Paradise.net.nz) with ESMTP id <0ITD007FM4DTGI@linda-3.paradise.net.nz> for pgsql-performance@postgresql.org; Fri, 20 Jan 2006 12:10:41 +1300 (NZDT) Received: from [192.168.1.11] (218-101-28-101.dsl.clear.net.nz [218.101.28.101]) by smtp-3.paradise.net.nz (Postfix) with ESMTP id 145F2391F7A; Fri, 20 Jan 2006 12:10:40 +1300 (NZDT) Date: Fri, 20 Jan 2006 12:10:32 +1300 From: Mark Kirkwood Subject: Re: Autovacuum / full vacuum (off-topic?) In-reply-to: <20060118225257.GY17896@pervasive.com> To: "Jim C. Nasby" Cc: Michael Crozier , pgsql-performance@postgresql.org Message-id: <43D01C68.3030204@paradise.net.nz> MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=ISO-8859-1 Content-transfer-encoding: 7bit X-Accept-Language: en-us, en User-Agent: Mozilla Thunderbird 1.0.6 (X11/20051106) References: <034701c61c46$f427df20$f20214ac@bite.lt> <60d5ipcw8y.fsf@dba2.int.libertyrms.com> <200601181115.51850.crozierm@conducivetech.com> <20060118225257.GY17896@pervasive.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.261 required=5 tests=[AWL=0.261] X-Spam-Score: 0.261 X-Spam-Level: X-Archive-Number: 200601/334 X-Sequence-Number: 16812 Jim C. Nasby wrote: > > I think it's a good idea, but you should take a look at the recently > added functionality that allows you to investigate the contests of the > FSM via a user function (this is either in 8.1 or in HEAD; I can't > remember which). AFAICS it is still in the patch queue for 8.2. It's called 'pg_freespacemap' and is available for 8.1/8.0 from the Pgfoundry 'backports' project: http://pgfoundry.org/projects/backports Cheers Mark