From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
---|---|
To: | Postgresql Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: logging stuff |
Date: | 2003-08-05 19:26:16 |
Message-ID: | 3F3004D8.8090704@dunslane.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Not quite the same - timestamps and pids have known formats, while db
names are almost arbitrary. I know including spaces in names is horrible
to my *nix way of thinking, but others might not have my prejudices.
(interesting question - what characters are NOT allowed in a database
name?).
BTW, we're talking about 5 extra chars per line here. I know it adds up,
but these days disk space is cheap and plentiful - for a million log
lines we're still only talking 5Mb (says he whose first machine had a
whopping 20Mb of disk space, and who paid hundreds of (aussie) dollars
for the extra 10 Mb.)
Syslog puts [] around pids, and typically has a lot of redundancy.
I'm prepared to be guided by concensus, though.
cheers
andrew
Tom Lane wrote:
>Andrew Dunstan <andrew(at)dunslane(dot)net> writes:
>
>
>>The dbname patch is now done. If nobody objects to the format
>>("[db:yourdbname]") I'll submit it - I did it that way to make it fairly
>>easy to split a log file based on it, although you would have to be
>>careful with multiline log entries such as query strings.
>>
>>
>
>I'd tend to just put the dbname in a known column, and not bother with
>the decoration --- decoration adds up fast when it's on every log line,
>and I don't think it helps make the log more parseable. Compare what we
>do with timestamps and pids.
>
> regards, tom lane
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-08-05 19:38:41 | Re: logging stuff |
Previous Message | Tom Lane | 2003-08-05 19:21:08 | Re: TODO: trigger features |