From: | Uncle George <gatgul(at)voicenet(dot)com> |
---|---|
To: | pgsql-ports(at)postgreSQL(dot)org |
Subject: | RedHat6.0 & Alpha |
Date: | 1999-07-14 10:23:22 |
Message-ID: | 378C651A.720BE65F@voicenet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-ports |
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 ).
From | Date | Subject | |
---|---|---|---|
Next Message | Hannu Krosing | 1999-07-14 10:27:54 | Re: [HACKERS] Interesting behaviour ! |
Previous Message | Duane Currie | 1999-07-14 08:49:51 | Re: [HACKERS] Counting bool flags in a complex query |
From | Date | Subject | |
---|---|---|---|
Next Message | Uncle George | 1999-07-14 10:29:52 | Re: [PORTS] Port Bug Report: postmaster/linux kernel unaligned trap errors |
Previous Message | Thomas Lockhart | 1999-07-14 05:47:13 | Re: [PORTS] Port Bug Report: No primary key possible with type reltime & timestamp |