Re: db size - Mailing list pgsql-performance

From Adrian Moisey
Subject Re: db size
Date
Msg-id 48032237.4040604@careerjunction.co.za
Whole thread Raw
In response to Re: db size  (PFC <lists@peufeu.com>)
Responses Re: db size  (PFC <lists@peufeu.com>)
Re: db size  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-performance
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@careerjunction.co.za
Phone: +27 21 686 6820 | Mobile: +27 82 858 7830 | Fax: +27 21 686 6842

pgsql-performance by date:

Previous
From: PFC
Date:
Subject: Re: db size
Next
From: PFC
Date:
Subject: Re: db size