On Thu, Nov 18, 2010 at 08:35, Tom Lane <t...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
