From: Tom Lane <tgl@sss.pgh.pa.us>
To: wbohl@deepdata.com
Cc: [ADMIN] <pgsql-admin@postgresql.org>
Subject: Re: Stopping vacuum
Date: Tue, 29 Jun 2004 22:41:47 -0400
Message-ID: <2786.1088563307@sss.pgh.pa.us> (raw)
In-Reply-To: <1088528969.30410.2.camel@sirio>
References: <1088528969.30410.2.camel@sirio>
Werner Bohl <wbohl@deepdata.com> writes:
> We have a very big db that was not vacuumed for a long time. We started
> vacuum 3 days ago and it has not finished yet. There are some urgent
> processes that have to be run against the db.
> Is it safe to kill vacuum? It was started with 'vacuum full analyze'
> Is there anyway to speed it up at next start?
It is safe in the sense that your database won't be corrupted (were it
not safe, vacuum would be too dangerous to use at all --- think of power
failures for instance).
However, whatever work vacuum has done on the current table will be lost
and need to be done over when you run it again. If the thing is stuck
on a particularly large and messy table then killing it could well be
counterproductive --- you might just be buying yourself an even longer
vacuum run next time.
I'd suggest identifying exactly which table it is currently working on
before you kill it. Then look into alternate methods of compacting that
table. It's entirely possible that CLUSTER would be a faster cleanup
method than VACUUM FULL.
regards, tom lane
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 from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, wbohl@deepdata.com
Subject: Re: Stopping vacuum
In-Reply-To: <2786.1088563307@sss.pgh.pa.us>
References: <1088528969.30410.2.camel@sirio> <2786.1088563307@sss.pgh.pa.us>
* 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