> Here is a patch that cancels autovacuum workers conflicting with
> DROP TABLE, TRUNCATE and CLUSTER. It was discussed here:

I made an adjustment for the latest 'more autovacuum fixes' patch.

Now, autovacuum workers handles ProcDie signals using ERROR
instead of FATAL. The exception is caught by the worker and
converted to the following logs.

  SIGINT -- Cancel the current job.
      LOG: autovacuum on <db>.<schema>.<table> is canceled
  SIGTERM -- Cancel all jobs.
      LOG: autovacuum on <db> is canceled

We are planning to ship 8.3 with autovacuum=on, so users will be
more likely to see conflicts between autovacuum and their commands.
This makes autovacuum more gentle.

ITAGAKI Takahiro
NTT Open Source Software Center

Attachment: cancel_autovac_on_drop-2.patch
Description: Binary data

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?


Reply via email to