Re: canceling autovacuum task woes

Robert Haas <robertmhaas@gmail.com>

From: Robert Haas <robertmhaas@gmail.com>

To: Tom Lane <tgl@sss.pgh.pa.us>

Cc: Alvaro Herrera <alvherre@commandprompt.com>, Andres Freund <andres@2ndquadrant.com>, Pg Hackers <pgsql-hackers@postgresql.org>

Date: 2012-07-24T20:14:01Z

Lists: pgsql-hackers

Attachments

more-autovac-cancel-logging.patch (application/octet-stream) patch

On Tue, Jul 24, 2012 at 4:09 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Robert Haas <robertmhaas@gmail.com> writes:
>> Yeah, you're right.  So you do get the table name.  But you don't get
>> the cause, which is what you really need to understand why it's
>> happening.  Attached is a patch that adds some more detail.
>
> Uh, what's the added dependency on pgstat.h for?  Looks sane to the
> eyeball otherwise.

Woops, that was leftovers from some earlier silliness that I (mostly)
removed before posting.

New version attached.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company