Re: fsm and vacuum

Le 03/12/2010 16:19, Little, Douglas a écrit :
> 
> 
> Sorry,  outlook must of clobbered the table.
> 
> [cid:image001.png@01CB92CB.11EA5F60]
> 
> 
> 
> Pg_attribute  has 513871 tuples and should take up 2135 pages.  It's currently allocated to 98646 pages.
> 
> Given that much bloat,  what would you suggest doing?
> 
> My guess is nothing.  The fsm/vacuum process will reuse empty slots over time.
> 

There's 96% of bloat? VACUUM FULL is needed here. According to your
numbers, it means you have a 770MB table of which only 16MB are actual data.


-- 
Guillaumehttp://www.postgresql.frhttp://dalibo.com