Tom Lane wrote:
> Luis Amigo <lamigo@atc.unican.es> writes:
> > again join and geometry(it also failed in postgres 7.1.3)
>
> The join discrepancy is probably an artifact of your local qsort()
> behaving slightly differently for equal keys than everyone else's.
> Curious that it only affects these few queries, though.
>
> Geometry differences in the low-order digits are par for the course.
> I wouldn't even stop to think about it, except that I see that you
> are already using a platform-specific geometry comparison file
> (geometry-irix.out). Some digging in the CVS logs and mail archives
> shows that that file was submitted by Pete Forman in Oct 2000, and
> he was using
>
> > Architecture (example: Intel Pentium) : SGI MIPS 8000
> >
> > Operating System (example: Linux 2.0.26 ELF) : IRIX 6.5.5m
> >
> > PostgreSQL version (example: PostgreSQL-7.1): PostgreSQL-7.1
> >
> > Compiler used (example: gcc 2.8.0): MIPSPro 7.3
>
> Not clear at this point if the differences in your results are due to
> hardware, library version, or compiler version differences.
>
> regards, tom lane
I've been searching for info that could explain round-up difference in
geometry.
I believe i've found a reasonable explanation, there is a architecture
disroupt between old MIPS3 FPUs
and newer MIPS4 FPUs.(so I'm almost sure that is the explanation).
I would like to know if is there anyone else running on IRIX, so we can
discuss these and other results
from another point of view.
Thanks for all your heavy working.
best wishes.