Thread: integer datetimes

Has any thought been given to making integer datetimes the default on 
platforms that support it? Are there any performance implications? I saw 
the Tom Lane raised this when it was added, and it looks like the 
decision was deferred. I know that, ceteris paribus, I would rather have 
fixed microsecond precision across a slightly smaller range in every app 
I've ever worked on. Which platforms don't support it? I did some search 
on all these questions but didn't find much info. I'm probably going to 
add the flag enabling it to the default buildfarm setup.

cheers

andrew

Andrew Dunstan <andrew@dunslane.net> writes:
> Has any thought been given to making integer datetimes the default on 
> platforms that support it? Are there any performance implications?

I don't know that anyone's done any serious performance comparisons.
My guess is there wouldn't be a noticeable difference, but that's just
a guess.

The real reason it's not default is portability worries.  We do not
currently have any fundamental functionality that breaks if you don't
have a working int64 datatype, and I'd just as soon not start.

I'm not real thrilled with the idea of a platform-dependent default,
either.

> I'm probably going to add the flag enabling it to the default
> buildfarm setup.

This should be selected for some buildfarm members but not all, just
like other configuration options.
        regards, tom lane

Tom Lane wrote:

>  
>
>>I'm probably going to add the flag enabling it to the default
>>buildfarm setup.
>>    
>>
>
>This should be selected for some buildfarm members but not all, just
>like other configuration options.
>
>
>  
>

We're very democratic - every member gets to choose their own config ;-)

cheers

andrew