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 whole thread)
Lists: pgsql-admin

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?


Werner Bohl <wbohl(at)deepdata(dot)com>
Infutor de Costa Rica


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-2015 The PostgreSQL Global Development Group