Re: Stopping vacuum

IIRC killing vacuums can cause some minor problems - i think it may have
been something like index bloat. Tom said something about it once before.

Otherwise, as I understand it, it's "safe" to kill vacuums.

Cheers
Iain

----- Original Message -----
From: "Werner Bohl" <wbohl(at)deepdata(dot)com>
To: "[ADMIN]" <pgsql-admin(at)postgresql(dot)org>
Sent: Wednesday, June 30, 2004 2:09 AM
Subject: [ADMIN] Stopping vacuum

> 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(at)deepdata(dot)com>
> Infutor de Costa Rica
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org