Re: WIP patch - INSERT-able log statements

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: WIP patch - INSERT-able log statements
Дата
Msg-id 1851.1172020098@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: WIP patch - INSERT-able log statements  ("FAST PostgreSQL" <fastpgs@fast.fujitsu.com.au>)
Ответы Re: WIP patch - INSERT-able log statements  ("FAST PostgreSQL" <fastpgs@fast.fujitsu.com.au>)
Re: WIP patch - INSERT-able log statements  (Greg Smith <gsmith@gregsmith.com>)
Список pgsql-patches
"FAST PostgreSQL" <fastpgs@fast.fujitsu.com.au> writes:
> - The log output will be in COPY format and will include the following
> information, irrespective of the log_line_prefix setting.
> ( timestamp_with_milliseconds, �timestamp, username, �databasename,
> sessionid, �host_and_port, host, proc_id, command_tag, �session_start,
> transaction_id, �error_severity, �SQL_State_Code, statement/error_message);

How exactly are you fitting the message structure
(primary/detail/context lines) into this?  It looks like your proposal
loses that structure ...

A smaller problem is that this forces people to incur a gettimeofday
call for every message logged; depending on your hardware that can be a
pretty nasty overhead.  Some people might find some of the other columns
not worth their weight, either.  Is it worth providing a knob to
determine the set of columns emitted?

            regards, tom lane

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

Предыдущее
От: "FAST PostgreSQL"
Дата:
Сообщение: Re: WIP patch - INSERT-able log statements
Следующее
От: "FAST PostgreSQL"
Дата:
Сообщение: Re: WIP patch - INSERT-able log statements