Re: [ADMIN] 9.5 new setting "cluster name" and logging

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: [ADMIN] 9.5 new setting "cluster name" and logging
Дата
Msg-id
27743.1476816473@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
Re: [ADMIN] 9.5 new setting "cluster name" and logging Andres Freund <andres@anarazel.de>
Re: [ADMIN] 9.5 new setting "cluster name" and logging Joe Conway <mail@joeconway.com>
Re: [ADMIN] 9.5 new setting "cluster name" and logging Thomas Munro <thomas.munro@enterprisedb.com>
Re: [ADMIN] 9.5 new setting "cluster name" and logging Stephen Frost <sfrost@snowman.net>
Re: [ADMIN] 9.5 new setting "cluster name" and logging Thomas Munro <thomas.munro@enterprisedb.com>
Re: [ADMIN] 9.5 new setting "cluster name" and logging Stephen Frost <sfrost@snowman.net>
Re: [ADMIN] 9.5 new setting "cluster name" and logging Robert Haas <robertmhaas@gmail.com>
Re: [ADMIN] 9.5 new setting "cluster name" and logging Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [ADMIN] 9.5 new setting "cluster name" and logging Tom Lane <tgl@sss.pgh.pa.us>
Robert Haas  writes:
> On Mon, Oct 17, 2016 at 6:24 PM, Stephen Frost  wrote:
>> I'm with Thomas on this and I disagree that the "csvlog bloat" argument
>> has merit.  If we're worried about bloat in csv then we should provide a
>> way for users to control what goes into the csvlog, not argue that
>> something which is clearly useful be excluded.

> I agree, but I think if we do that it would be highly desirable do
> something to make the format discoverable.  For example, at the
> beginning of each file and whenever the format changes, we write some
> kind of unmistakable header line into the file identifying what fields
> will be present on each line thereafter.  It's undesirable for log
> analysis tools to need to contain logic that tries (imperfectly, no
> doubt) to reverse-engineer the field list.

Automatic "csv header" at the start of each logfile, perhaps?  And
force a logfile switch if it changes.

			regards, tom lane

В списке pgsql-hackers по дате отправления
От: Alvaro Herrera
Дата:
От: Joshua D. Drake
Дата:
Сообщение: Re: Indirect indexes
FAQ