RedHat6.0 & Alpha

Поиск
Список
Период
Сортировка
От Uncle George
Тема RedHat6.0 & Alpha
Дата
Msg-id 378C651A.720BE65F@voicenet.com
обсуждение исходный текст
Ответ на Port Bug Report: No primary key possible with type reltime & timestamp  (Unprivileged user <nobody>)
Ответы Re: [PORTS] RedHat6.0 & Alpha  (Bruce Momjian <maillist@candle.pha.pa.us>)
Список 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 ).


В списке pgsql-ports по дате отправления:

Предыдущее
От: Thomas Lockhart
Дата:
Сообщение: Re: [PORTS] Port Bug Report: No primary key possible with type reltime & timestamp
Следующее
От: Uncle George
Дата:
Сообщение: Re: [PORTS] Port Bug Report: postmaster/linux kernel unaligned trap errors