Re: We need to log aborted autovacuums - Mailing list pgsql-hackers

From Itagaki Takahiro
Subject Re: We need to log aborted autovacuums
Date
Msg-id AANLkTinVC0e3OQGHc+BzfkSG8kg+WCebmkS_p=e7FwK_@mail.gmail.com
Whole thread Raw
In response to Re: We need to log aborted autovacuums  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: We need to log aborted autovacuums
List pgsql-hackers
On Thu, Nov 18, 2010 at 08:35, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Yeah, it would be really good to be able to log that without bumping the
>> log levels of the server in general to DEBUG3.
>
> Well, the way to deal with that would be to add a GUC that enables
> reporting of those messages at LOG level.  But it's a bit hard to argue
> that we need such a thing without more evidence.  Maybe you could just
> locally modify the DEBUG3 to LOG and see whether it teaches you
> anything?

How about adding a special role for autovacuum, and running autovacuum
by the role instead of the database owner? If we have "autovacuum" role
for autovacuum processes, we could set log_min_messages to DEBUG3 for
only the role with per-user configuration.

--
Itagaki Takahiro


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: We need to log aborted autovacuums
Next
From: Tom Lane
Date:
Subject: Re: We need to log aborted autovacuums