"FAST PostgreSQL" <[EMAIL PROTECTED]> 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);
Advertising
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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
