by adrian@[EMAIL PROTECTED]
(Adrian Moisey)
Apr 14, 2008 at 11:21 AM
Hi
> If you suspect your tables or indexes are bloated, restore your dump
> to a test box.
> Use fsync=off during restore, you don't care about integrity on the
> test box.
> This will avoid slowing down your production database.
> Then look at the size of the restored database.
> If it is much smaller than your production database, then you have
> bloat.
I have done that, and I get the following:
the live one is 113G
the restored one is 78G
How should I get rid of the bloat?
VACUUM FULL?
--
Adrian Moisey
Systems Administrator | CareerJunction | Your Future Starts Here.
Web: www.careerjunction.co.za | Email: adrian@[EMAIL PROTECTED]
+27 21 686 6820 | Mobile: +27 82 858 7830 | Fax: +27 21 686 6842
--
Sent via pgsql-performance mailing list (pgsql-performance@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
