Re: Routine maintenance - vacuum, analyse and autovacuum - Mailing list pgsql-admin

From Bruno Wolff III
Subject Re: Routine maintenance - vacuum, analyse and autovacuum
Date
Msg-id 20040129130847.GC17068@wolff.to
Whole thread Raw
In response to Routine maintenance - vacuum, analyse and autovacuum  ("Iain" <iain@mst.co.jp>)
List pgsql-admin
On Thu, Jan 29, 2004 at 18:59:28 +0900,
  Iain <iain@mst.co.jp> wrote:

I haven't used auto_vacuum, but I seen comments on the lists indicating
that it works OK.

> If I start a VACUUM FULL, is it ok to interrupt it part way through? I mean,
> is a partially completed vacuum full worth anything, and is there any danger
> in routinely killing it?

With 7.4 you shouldn't have to do VACUUM FULL. If you have FSM set high
enough, then normal VACUUM should suffice. The exception would be if
you ran something that may the DB much larger than normal and you wanted
to shrink the space used by the DB. Then you would need to run a VACUUM FULL.

pgsql-admin by date:

Previous
From: "Iain"
Date:
Subject: Routine maintenance - vacuum, analyse and autovacuum
Next
From: Jodi Kanter
Date:
Subject: Re: [Fwd: binary tree query]