Skip site navigation (1) Skip section navigation (2)

Stopping vacuum

From: Werner Bohl <wbohl(at)deepdata(dot)com>
To: "[ADMIN]" <pgsql-admin(at)postgresql(dot)org>
Subject: Stopping vacuum
Date: 2004-06-29 17:09:29
Message-ID: 1088528969.30410.2.camel@sirio (view raw or flat)
Thread:
Lists: 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(at)deepdata(dot)com>
Infutor de Costa Rica


Responses

pgsql-admin by date

Next:From: CHRIS HOOVERDate: 2004-06-29 17:30:00
Subject: Re: Stopping vacuum
Previous:From: juanmimeDate: 2004-06-29 16:56:53
Subject: Asunto: Re: pg_restore usage

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group