Search Postgresql Archives

Re: full vacuum cancelation

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





On Thu, Oct 21, 2010 at 5:00 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
=?UTF-8?Q?Viktor_Bojovi=C4=87?= <viktor.bojovic@xxxxxxxxx> 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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux