RedHat6.0 & Alpha

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

In response to

Responses

Browse pgsql-hackers by date

  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

Browse pgsql-ports by date

  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