Re: [PROPOSAL] Inputs on forcing VACUUM VERBOSE to write timestamp

Поиск
Список
Период
Сортировка
От dinesh kumar
Тема Re: [PROPOSAL] Inputs on forcing VACUUM VERBOSE to write timestamp
Дата
Msg-id CALnrH7qqwbgUyM7o=HjCTENWFHP2vbyV7msoDM53PF=HM2tQKw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [PROPOSAL] Inputs on forcing VACUUM VERBOSE to write timestamp  (Andres Freund <andres@anarazel.de>)
Список 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
> <http://www.postgresql.org/message-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
 
Greetings,

Andres Freund

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Performance improvement for joins where outer side is unique
Следующее
От: "Shulgin, Oleksandr"
Дата:
Сообщение: Re: Proposal: Implement failover on libpq connect level.