RedHat6.0 & Alpha
Uncle George <gatgul@voicenet.com>
From: Uncle George <gatgul@voicenet.com>
To: pgsql-ports@postgreSQL.org
Date: 1999-07-14T10:23:22Z
Lists: pgsql-hackers
Porting: 1) Seems like -O0/-O1 works best for this machine. It appears u get spin lock errors/timeouts if i optimize at -O3, and -O2 2) in nabstime.h, the typedefs AbsoluteTime & RelativeTime ( was that Absolutetime & Relativetime ) should be kept at a fixed ( for all ports ) size like int32. Adjusting it to what ever size time_t becomes leads to problems with 'signed' words v. 'non-signed' extended longwords. For instance the constant 0x80000001 is a negative 32bit integer, but as a time_t it just a large positive number!. 3) Having problems with sign extension also creates problems for '@ 3 seconds ago'::reltime. see #2 4) You dont store reltime or abstime as 64bit's into the db. Are there any plans to use 64bit alpha/linux timevalues as reltime & abstime ? maybe reltime64 & abstime64? whats the sql world doing with 'seconds since 1970' if the year is > 2038 ( which is the 32bit signed overflow ) ? 5) having $(CC) -mieee all over just isn't good, particular if no float operations are done. It slows down everthing. Is there a way to limit this in the makefile? gat BTW these are porting issues ( but as well hacking issues ).