Stopping vacuum - Mailing list pgsql-admin

From Werner Bohl
Subject Stopping vacuum
Date
Msg-id 1088528969.30410.2.camel@sirio
Whole thread Raw
Responses Re: Stopping vacuum  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Hi,

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?


TIA,

--
Werner Bohl <wbohl@deepdata.com>
Infutor de Costa Rica


pgsql-admin by date:

Previous
From: Ivo Rossacher
Date:
Subject: Re: Change the character encoding of a database
Next
From: juanmime@ono.com
Date:
Subject: Asunto: Re: pg_restore usage