| From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
|---|---|
| To: | "Little, Douglas" <DOUGLAS(dot)LITTLE(at)orbitz(dot)com> |
| Cc: | PgAdmin Support <pgadmin-support(at)postgresql(dot)org> |
| Subject: | Re: fsm and vacuum |
| Date: | 2010-12-03 15:50:05 |
| Message-ID: | 4CF911AD.5000507@lelarge.info |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
Le 03/12/2010 16:19, Little, Douglas a écrit :
>
>
> Sorry, outlook must of clobbered the table.
>
> [cid:image001(dot)png(at)01CB92CB(dot)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.
--
Guillaume
http://www.postgresql.fr
http://dalibo.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Willy-Bas Loos | 2010-12-04 01:40:30 | [ADMIN] syntax error for no apparent reason |
| Previous Message | Guillaume Lelarge | 2010-12-03 15:44:33 | Re: fsm and vacuum |