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. -- Guillaume http://www.postgresql.fr http://dalibo.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
