Excerpts from Alvaro Herrera's message of mar jul 24 15:30:49 -0400 2012: > > > On Tuesday, July 24, 2012 07:48:27 PM Robert Haas wrote: > > > I am running into a lot of customer situations where the customer > > > reports that "canceling autovacuum task" shows up in the logs, and > > > it's unclear whether this is happening often enough to matter, and > > > even more unclear what's causing it. > > > > > > Me: So, do you know what table it's getting cancelled on? > > > Customer: Nope.
> Hm, autovacuum is supposed to set an errcontext callback that would tell > you the table name it's working on at the time of the cancel. So if > even that is missing, something strange is going on. Yep, it says: ERROR: canceling autovacuum task CONTEXT: automatic vacuum of table "alvherre.public.foo" So at least that part seems pilot error more than anything else. -- Álvaro Herrera <alvhe...@commandprompt.com> The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers