Re: integer datetimes - Mailing list pgsql-hackers

From Tom Lane
Subject Re: integer datetimes
Date
Msg-id 26584.1103221428@sss.pgh.pa.us
Whole thread Raw
In response to integer datetimes  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: integer datetimes
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: join selectivity
Next
From: Andrew Dunstan
Date:
Subject: Re: integer datetimes