[PROPOSAL] Inputs on forcing VACUUM VERBOSE to write timestamp
Hi All,
Greetings for the day.
Would like to know your inputs/suggestions on below proposal. Kindly let me
know, if it's already taken care.
*Proposal*
Forcing VACUUM VERBOSE to write timestamp, for each "INFO" entry. This was
raised already in this
</messages/by-id/20031110162349.65542.qmail@web21408.mail.yahoo.com>
thread, and wanted to discuss it again. I didn't see any replies on this
old thread.
*Justification*
As we are recording the timestamp too, it gives an idea about how much time
it took for each VACUUM activity.
Regards,
Dinesh
manojadinesh.blogspot.com
Hi,
On 2015-09-03 21:45:52 +0530, dinesh kumar wrote:
Forcing VACUUM VERBOSE to write timestamp, for each "INFO" entry. This was
raised already in this
</messages/by-id/20031110162349.65542.qmail@web21408.mail.yahoo.com>
thread, and wanted to discuss it again. I didn't see any replies on this
old thread.
Unconvinced - sounds like you're just re-inventing log_line_prefix.
Greetings,
Andres Freund
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
On Thu, Sep 3, 2015 at 9:48 PM, Andres Freund <andres@anarazel.de> wrote:
Hi,
On 2015-09-03 21:45:52 +0530, dinesh kumar wrote:
Forcing VACUUM VERBOSE to write timestamp, for each "INFO" entry. This
was
raised already in this
</messages/by-id/20031110162349.65542.qmail@web21408.mail.yahoo.com
thread, and wanted to discuss it again. I didn't see any replies on this
old thread.Unconvinced - sounds like you're just re-inventing log_line_prefix.
Thanks for your inputs.
I thought, it will be helpful without modifying the log_min_messages
parameter. Otherwise, we have to run the vacuum verbose, by modifying the
log_min_messages at session level, which will be recorded in pg_log.
If we allow VERBOSE to log timestamp, we can have it in stdout, which can
be diverted to a required log file. This will be useful for the vacuumdb
binary too.
Let me know your thoughts.
Regards,
Dinesh
manojadinesh.blogspot.com
Show quoted text
Greetings,
Andres Freund
On Thu, Sep 3, 2015 at 9:18 AM, Andres Freund <andres@anarazel.de> wrote:
Hi,
On 2015-09-03 21:45:52 +0530, dinesh kumar wrote:
Forcing VACUUM VERBOSE to write timestamp, for each "INFO" entry. This
was
raised already in this
</messages/by-id/20031110162349.65542.qmail@web21408.mail.yahoo.com
thread, and wanted to discuss it again. I didn't see any replies on this
old thread.Unconvinced - sounds like you're just re-inventing log_line_prefix.
Many times I've wanted a client_log_line_prefix. If someone wants to
invent that, I'd second it.
Cheers,
Jeff
On 9/3/15 1:50 PM, Jeff Janes wrote:
Unconvinced - sounds like you're just re-inventing log_line_prefix.
Many times I've wanted a client_log_line_prefix. If someone wants to
invent that, I'd second it.
It would be pretty awkward to have to turn that on and off to run a
manual vacuum, unless there was a LOGTIME option added to vacuum as well.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers