Re: Interval aggregate regression failure (expected seems

Поиск
Список
Период
Сортировка
От Gregory Maxwell
Тема Re: Interval aggregate regression failure (expected seems
Дата
Msg-id e692861c0511071207w7696ea4av267c50fa687a7a07@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Interval aggregate regression failure (expected seems  (Greg Stark <gsstark@mit.edu>)
Ответы Re: Interval aggregate regression failure (expected seems  (Michael Paesold <mpaesold@gmx.at>)
Список pgsql-hackers
On 07 Nov 2005 14:22:37 -0500, Greg Stark <gsstark@mit.edu> wrote:
> IIRC, floating point registers are actually longer than a double so if the
> entire calculation is done in registers and then the result rounded off to
> store in memory it may get the right answer. Whereas if it loses the extra
> bits on the intermediate values (the infinite repeating fractions) that might
> be where you get the imprecise results.

Hm. I thought -march=pentium4 -mcpu=pentium4 implies -mfpmath=sse.
SSE is a much better choice on P4 for performance reasons, and never
has excess precision. I'm guessing from the above that I'm incorrect,
in which case we should always be compiled with -mfpmath=sse -msse2
when we are complied -march=pentium4, this should remove problems
caused by excess precision. The same behavior can be had on non sse
platforms with -ffloat-store.


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

Предыдущее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Crash during elog.c...
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Crash during elog.c...