Re: integer datetimes

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: integer datetimes
Date: 2004-12-16 18:23:48
Message-ID: 26584.1103221428@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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
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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2004-12-16 18:42:49 Re: integer datetimes
Previous Message Tom Lane 2004-12-16 17:56:24 Re: join selectivity