Re: Manual vacs 5x faster than autovacs?

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: Dave Crooke <dcrooke(at)gmail(dot)com>
Cc: Wayne Beaver <wayne(at)acedsl(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Manual vacs 5x faster than autovacs?
Date: 2009-11-14 03:31:59
Message-ID: 4AFE24AF.1060308@postnewspapers.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 13/11/2009 2:29 PM, Dave Crooke wrote:

> Beware that VACUUM FULL locks an entire table at a time :-)

... and often bloats its indexes horribly. Use CLUSTER instead if you
need to chop a table that's massively bloated down to size; it'll be
much faster, and shouldn't leave the indexes in a mess.

I increasingly wonder what the purpose of VACUUM FULL in its current
form is.

--
Craig Ringer

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2009-11-14 03:55:12 Re: Manual vacs 5x faster than autovacs?
Previous Message Kenny Gorman 2009-11-13 21:35:57 Re: SSD + RAID