From: Adrian Moisey <adrian@careerjunction.co.za>
To: PFC <lists@peufeu.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: db size
Date: Mon, 14 Apr 2008 11:21:59 +0200
Message-ID: <48032237.4040604@careerjunction.co.za> (raw)
In-Reply-To: <op.t9lf4tvrcigqcu@apollo13.peufeu.com>
References: <4802F9E4.3000704@careerjunction.co.za>
<op.t9lf4tvrcigqcu@apollo13.peufeu.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: adrian@careerjunction.co.za, lists@peufeu.com
Subject: Re: db size
In-Reply-To: <48032237.4040604@careerjunction.co.za>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox