Re: [PORTS] RedHat6.0 & Alpha

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: Uncle George <gatgul(at)voicenet(dot)com>
Cc: pgsql-ports(at)postgreSQL(dot)org
Subject: Re: [PORTS] RedHat6.0 & Alpha
Date: 1999-07-14 15:11:50
Message-ID: 199907141511.LAA23001@candle.pha.pa.us
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

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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Ansley, Michael 1999-07-14 15:12:06 RE: [HACKERS] MAX Query length
Previous Message Tom Lane 1999-07-14 15:10:38 Re: [HACKERS] What does explain show ?

Browse pgsql-ports by date

  From Date Subject
Next Message Uncle George 1999-07-15 00:39:24 Re: [PORTS] RedHat6.0 & Alpha
Previous Message Thomas Lockhart 1999-07-14 13:40:25 Re: [PORTS] Port Bug Report: \d -> ERROR: nodeRead: Bad type 0