Re: Autovacuum cancellation - Mailing list pgsql-patches

From Tom Lane
Subject Re: Autovacuum cancellation
Date
Msg-id 10623.1193403587@sss.pgh.pa.us
Whole thread Raw
In response to Re: Autovacuum cancellation  (Gregory Stark <stark@enterprisedb.com>)
Responses Re: Autovacuum cancellation  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-patches
Gregory Stark <stark@enterprisedb.com> writes:
> I assume the right thing happens if multiple deadlock check signals fire for
> the same autovacuum?

Multiple signals shouldn't be a problem, but late-arriving ones could be.
It might be worth having autovac explicitly clear QueryCancelPending
after it's finished a table, so that a SIGINT sent because of activity
on one table couldn't force cancellation of vacuum on the next one.

            regards, tom lane

pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: Autovacuum cancellation
Next
From: Tom Lane
Date:
Subject: Re: fix ZIC dependency on postgres.h