Re: Autovacuum cancellation

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