Re: "canceling autovacuum time" - Mailing list pgsql-general

From Ondrej Ivanič
Subject Re: "canceling autovacuum time"
Date
Msg-id CAM6mieJ+MkKU_hBHn8va0t5ESFvCSDYH40fViG8fv0CpZyz5Og@mail.gmail.com
Whole thread Raw
In response to "canceling autovacuum time"  (Jameison Martin <jameisonb@yahoo.com>)
List pgsql-general
Hi,

On 28 February 2012 11:53, Jameison Martin <jameisonb@yahoo.com> wrote:
> I'm seeing "GMTERROR: canceling autovacuum task" lines in my logs.

That's *should* be fine. autovacuum daemon is smart enough to cancel
it self when other query needs access to the table. The affected table
will be vacuumed/analysed later. You should monitor
pg_stat_user_tables view to see how often is the table
vacuumed/analysed.

--
Ondrej Ivanic
(ondrej.ivanic@gmail.com)

pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: accumulating handles problem on machine running postgresql
Next
From: chinnaobi
Date:
Subject: Re: PSQL 9.1 Streaming Replication Windows 2008 64 bit Servers