Re: Interval aggregate regression failure (expected seems

From: Michael Paesold <mpaesold(at)gmx(dot)at>
To: Gregory Maxwell <gmaxwell(at)gmail(dot)com>
Cc: Greg Stark <gsstark(at)mit(dot)edu>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Michael Glaesemann <grzm(at)myrealbox(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Interval aggregate regression failure (expected seems
Date: 2005-11-08 21:07:35
Message-ID: 43711397.7070203@gmx.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Gregory Maxwell wrote:
> On 07 Nov 2005 14:22:37 -0500, Greg Stark <gsstark(at)mit(dot)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.

Just for the record (and those interested): using 'CFLAGS=-O2
-mcpu=pentium4 -march=pentium4 -mfpmath=sse -msse2' actually passes the
regression tests.

Best Regards,
Michael Paesold

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Creager 2005-11-08 21:09:35 Re: Assert failure found in 8.1RC1
Previous Message Gavin Sherry 2005-11-08 20:38:23 lc_numeric and decimal delimiter

Browse pgsql-patches by date

  From Date Subject
Next Message Michael Paesold 2005-11-08 21:13:17 Re: Interval aggregate regression failure (expected seems
Previous Message Tom Lane 2005-11-08 17:34:05 Re: Improve the comparison of NUMERIC data