Postgres Pro
Downloads
Home   >   mailing lists

Re: full vacuum cancelation - Mailing list pgsql-general

From Vick Khera
Subject Re: full vacuum cancelation
Date
Msg-id AANLkTinS+CyqhbJJxb_jjrRVW0jc_swJZvH=DXyvhyjP@mail.gmail.com
Whole thread Raw
In response to full vacuum cancelation  (Viktor Bojović <viktor.bojovic@gmail.com>)
List pgsql-general
Tree view 
On Thu, Oct 21, 2010 at 9:15 AM, Viktor Bojović
<viktor.bojovic@gmail.com> wrote:
> my full vacuuming of one table runs still after four days. Is it safe to
> cancel it by pressing Ctrl+c?

Is it really running (as in progressing with its work) or is it
blocking waiting for a lock?  Check the pg_stat_activity view to see
what it is doing.  How big is this table?

pgsql-general by date:

Previous
From: "A.M."
Date:
Subject: Re: Custom cache implemented in a postgresql C function
Next
From: Brian Hirt
Date:
Subject: Re: Updates, deletes and inserts are very slow. What can I do make them bearable?