Re: [HACKERS] Explicit relation name in VACUUM VERBOSE log - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: [HACKERS] Explicit relation name in VACUUM VERBOSE log
Date
Msg-id CAB7nPqRDvR=nbdd0nVGGumQuL+-hDrgpRLRsUx_XiqBKyynpHg@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] Explicit relation name in VACUUM VERBOSE log  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: [HACKERS] Explicit relation name in VACUUM VERBOSE log
List pgsql-hackers
On Tue, Aug 15, 2017 at 11:14 AM, Alvaro Herrera
<alvherre@2ndquadrant.com> wrote:
>> In vacuum_rel()@vacuum.c, there are a couple of logs that could be
>> improved as well with the schema name.
>
> I agree that there's a lot of room for improvement there.  If I'm
> allowed some scope creep, I'd say that gathering detailed vacuum info
> from both autovacuum and user-invoked vacuum in a central place would be
> very welcome.

Hm. I am not sure what you have in mind here. The existing logs are
spread all other the place, and it is useful to VERBOSE information
when things are being run, bot just once a run has been done (if what
you mean here is to store vacuum verbose-related stats for each
relation in memory and then spawn it all at once, or we could log this
info and also store them).
-- 
Michael



pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: [HACKERS] What users can do with custom ICU collations inPostgres 10
Next
From: Craig Ringer
Date:
Subject: Re: [HACKERS] What users can do with custom ICU collations inPostgres 10