Re: How To Log User Name + Database?

Tom Lane wrote:
>
> Ed Loehr <eloehr@austin.rr.com> writes:
> > Would it be better to
> > (optionally) allow the db name and user name to be logged on each
> > line?
>
> That would bulk up the log considerably, and also create formatting
> problems (you couldn't really make these items be fixed-width columns).

These points, at least the first, suggest to me it should be an optional
feature.  But regarding bulkier logs, FWIW, I would gladly trade the
time/hassle of correlating visually correlating log entries for
additional disk space.  Time is far more expensive than disk space.
Regarding fixed width problems, not sure why fixed-width columns would be
a requirement.  I'll assume it is some unusual internal pg formatting
constraint.  Apache and others obviously handle variable width logging...

Regards,
Ed Loehr