Re: [PORTS] RedHat6.0 & Alpha - Mailing list pgsql-ports

From Bruce Momjian
Subject Re: [PORTS] RedHat6.0 & Alpha
Date
Msg-id 199907141511.LAA23001@candle.pha.pa.us
Whole thread Raw
In response to RedHat6.0 & Alpha  (Uncle George <gatgul@voicenet.com>)
List 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

Yes, the 6.5.1 code will use:

    CFLAGS:-O -mieee  # optimization -O2 removed because of egcs problem

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

OK, the real problem is that we are using "magic" values to mark certain
values, and this is not done portably.  Can you suggestion good values?
Can you send over a patch?

> 3) Having problems with sign extension also creates problems for '@ 3
> seconds ago'::reltime.  see #2

Same thing.  We should not be using hard-coded values.

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

Not sure on this.

> 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

What does that flag do, and where would it be needed or not needed?

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-ports by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: [PORTS] Port Bug Report: \d -> ERROR: nodeRead: Bad type 0
Next
From: Uncle George
Date:
Subject: Re: [PORTS] RedHat6.0 & Alpha