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