Andrew Dunstan <andrew(at)dunslane(dot)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
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,
> 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
In response to
pgsql-hackers by date
|Next:||From: Andrew Dunstan||Date: 2004-12-16 18:42:49|
|Subject: Re: integer datetimes|
|Previous:||From: Tom Lane||Date: 2004-12-16 17:56:24|
|Subject: Re: join selectivity |