Re: db size

From: Adrian Moisey <adrian(at)careerjunction(dot)co(dot)za>
To: PFC <lists(at)peufeu(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: db size
Date: 2008-04-14 09:21:59
Message-ID: 48032237.4040604@careerjunction.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)careerjunction(dot)co(dot)za
Phone: +27 21 686 6820 | Mobile: +27 82 858 7830 | Fax: +27 21 686 6842

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message PFC 2008-04-14 09:33:54 Re: db size
Previous Message PFC 2008-04-14 09:18:19 Re: db size