Re: What is a typical precision of gettimeofday()? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: What is a typical precision of gettimeofday()?
Date
Msg-id 603162.1751935035@sss.pgh.pa.us
Whole thread Raw
In response to Re: What is a typical precision of gettimeofday()?  (Vik Fearing <vik@postgresfriends.org>)
List pgsql-hackers
Vik Fearing <vik@postgresfriends.org> writes:
> Having read through this thread, is there any chance at all that we 
> might be able to implement feature F555, “Enhanced seconds precision”?

Don't see how we could do that without an on-disk compatibility break
for timestamps.  Also, AFAICS there's no way to stuff nanosecond
precision and a reasonable timestamp range (at least a few thousand
years IMO) into 64 bits, so the compatibility break would include
expending more disk space.  Hard to believe that it's worth it.

(If we did decide to break compatibility, my own first priority
would be to make timestamptz actually include a timezone ...)

            regards, tom lane



pgsql-hackers by date:

Previous
From: Peter Smith
Date:
Subject: Re: [WIP]Vertical Clustered Index (columnar store extension) - take2
Next
From: Vik Fearing
Date:
Subject: Re: What is a typical precision of gettimeofday()?