Re: [PATCHES] Re: microsecond log timestamps - Mailing list pgsql-general

From Tom Lane
Subject Re: [PATCHES] Re: microsecond log timestamps
Date
Msg-id 3346.989766775@sss.pgh.pa.us
Whole thread Raw
In response to Re: [PATCHES] Re: microsecond log timestamps  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
Peter Eisentraut <peter_e@gmx.net> writes:
> I am opposed to the unreadable, non-standard timestamp format.

I didn't see the point of Ed's arbitrary change in YMD format, but
what's wrong with adding fractional seconds?  Our own timestamp code
is willing to format fractional seconds, so we can hardly call it
nonstandard.

> I also don't see the point of microsecond granularity.

What Ed implemented (which is what was in 7.0 and before) is millisecond
resolution, which does seem worthwhile; certainly one-second resolution
is pretty coarse on some machines these days.

I was thinking of keeping the YMD display format the same but otherwise
adopting the patch.

            regards, tom lane

pgsql-general by date:

Previous
From: Vince Vielhaber
Date:
Subject: Re: [PATCHES] Re: microsecond log timestamps
Next
From: Tom Lane
Date:
Subject: Re: Bug with timestamp !!!