Re: extra info on autovaccum log

Gaetano Mendola wrote:

> I don't have idea about the database involved, I suggest:
>
>
> Performing: VACUUM ANALYZE "dbame"."public"."current_connection"
>
> or
>
> Performing: VACUUM ANALYZE "public"."current_connection"@"dbname"
>
>
> I know that I will know the database on the very next line, but sometimes
> is too late :-( 


I have thought about this before.  I didn't do it since as you say, you 
can figure it out from looking at later log lines, but also that the log 
line entries are already very long and will only get longer with the 
extra info.

BTW, I believe this will be moot in 7.5 since autovacuum will be 
integrated into the backend and uses elog calls, so you can format the 
log entries using GUC variables.

Matthew