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