Re: full vacuum cancelation

From: Vick Khera <vivek(at)khera(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: full vacuum cancelation
Date: 2010-10-21 15:11:38
Message-ID: AANLkTinS+CyqhbJJxb_jjrRVW0jc_swJZvH=DXyvhyjP@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Oct 21, 2010 at 9:15 AM, Viktor Bojović
<viktor(dot)bojovic(at)gmail(dot)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?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message A.M. 2010-10-21 15:14:40 Re: Custom cache implemented in a postgresql C function
Previous Message Richard Broersma 2010-10-21 15:06:36 Re: Updates, deletes and inserts are very slow. What can I do make them bearable?