Re: full vacuum cancelation - Mailing list pgsql-general

From Tom Lane
Subject Re: full vacuum cancelation
Date
Msg-id 23760.1287673203@sss.pgh.pa.us
Whole thread Raw
In response to full vacuum cancelation  (Viktor Bojović <viktor.bojovic@gmail.com>)
Responses Re: full vacuum cancelation
List pgsql-general
=?UTF-8?Q?Viktor_Bojovi=C4=87?= <viktor.bojovic@gmail.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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Custom cache implemented in a postgresql C function
Next
From: David Kerr
Date:
Subject: Re: Generate a dynamic sequence within a query