Обсуждение: 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