Re: Vacuum full considered useful ;)

From: Vivek Khera <vivek(at)khera(dot)org>
To: Pgsql performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Vacuum full considered useful ;)
Date: 2007-07-15 02:26:22
Message-ID: 700E00A2-704B-41BA-8604-A8A06513B544@khera.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


On Jul 14, 2007, at 11:50 AM, Patric de Waha wrote:

> Yesterday I switched from 8.1 to 8.2. So I needed to dump the
> dbase
> and reimport it. The dbase after 4 months of running without
> "vacuum full"
> reached 60 gigabyte of diskspace. Now after a fresh import it
> only has 5 gigabyte!

After a couple more months running 8.2, compare your index sizes to
what they are now relative to the table sizes. My bet is that if you
just reindexed some of your tables that would have cleared out much
of that bloat.

A short while back I reindexed some tables on my primary production
server and shaved off about 20Gb of disk space. The table itself was
not bloated. A dump/reload to another server resulted in a table of
roughly the same size.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message angga erwina 2007-07-15 16:37:58 slony over LAN and VPN
Previous Message Guillaume Lelarge 2007-07-14 16:34:18 Re: Vacuum full considered useful ;)