Skip site navigation (1) Skip section navigation (2)

Re: vacuum verbose relations reporting

From: Jeff Frost <jeff(at)frostconsultingllc(dot)com>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-admin(at)postgresql(dot)org
Subject: Re: vacuum verbose relations reporting
Date: 2008-08-31 16:46:32
Message-ID: Pine.LNX.4.64.0808310941020.4517@discord.home.frostconsultingllc.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Sun, 31 Aug 2008, Alvaro Herrera wrote:

> Jeff Frost wrote:
>
>> I guess this isn't entirely accurate, as the above script returns 35883,
>> but vacuum verbose returns:
>>
>> INFO:  free space map contains 111435 pages in 10005 relations
>
> Well, what this means is that not every single table has useful free
> space ...

Ohh...naturally.  So, max_fsm_relations only cares about relations that have 
free space to track, and not all relations.  So, is there a way to compute 
the number of relatinos with useful free space?


-- 
Jeff Frost, Owner 	<jeff(at)frostconsultingllc(dot)com>
Frost Consulting, LLC 	http://www.frostconsultingllc.com/
Phone: 916-647-6411	FAX: 916-405-4032

In response to

pgsql-admin by date

Next:From: Vishal AroraDate: 2008-09-01 06:10:29
Subject: Re: Configure DB
Previous:From: Alvaro HerreraDate: 2008-08-31 16:31:40
Subject: Re: vacuum verbose relations reporting

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group