Re: full vacuum cancelation

From: Viktor Bojović <viktor(dot)bojovic(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: full vacuum cancelation
Date: 2010-10-23 08:21:16
Message-ID: AANLkTinym0FbW0USNVDTyRi+PhNTZaogWMkuuNTbrQR7@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Oct 21, 2010 at 5:00 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> =?UTF-8?Q?Viktor_Bojovi=C4=87?= <viktor(dot)bojovic(at)gmail(dot)com> writes:
> > my full vacuuming of one table runs still after four days. Is it safe to
> > cancel it by pressing Ctrl+c?
>
> I assume this is a pre-9.0 Postgres version?
>
> Depending on how far along the vacuum actually is, there's a possibility
> that trying to cancel it will cause a PANIC, but that will not damage
> your data --- the worst consequence would be killing any other sessions
> that are running concurrently.
>
> regards, tom lane
>

version is 8.3.x , everything went fine. thanx.

--
---------------------------------------
Viktor Bojović
---------------------------------------
Wherever I go, Murphy goes with me

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2010-10-23 09:50:57 Re: server error
Previous Message quickinfo quickinfo 2010-10-23 07:19:32 server error