Re: Integer datetimes - Mailing list pgsql-hackers

From Zdenek Kotala
Subject Re: Integer datetimes
Date
Msg-id 463CB3EC.4060707@sun.com
Whole thread Raw
In response to Integer datetimes  (Neil Conway <neilc@samurai.com>)
Responses Re: Integer datetimes  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
Neil Conway wrote:

> So, are there any corresponding benefits to providing both FP and
> integer datetimes? AFAIK the following differences in user-visible
> behavior exist:
> 

There should be also problem with floating point implementation on 
client and server side. For example if somebody use floating point 
optimalization (-fast switch in Sun Studio) for server compilation and 
client will be connected from another machine with standard floating 
point behavior. Result could be wrong.

> 
> P.S. One thing to verify is that the performance of integer datetimes is
> no worse than the perf. of FP datetimes. I'd intuitively expect this to
> be true, but it would be worth investigating.

Some multi core/thread CPUs has only one FPU (e.g. Niagara).

    Zdenek


pgsql-hackers by date:

Previous
From: "Dave Page"
Date:
Subject: Re: New idea for patch tracking
Next
From: Andrew Dunstan
Date:
Subject: iterating over relation's attributes