Re: [HACKERS] horo(r)logy test fail on solaris (again and

2006-10-02 Thread Bruce Momjian
Thanks for the analysis. I have removed mention of the -fast option from the Solaris FAQ. --- Kenneth Marshall wrote: > On Wed, Sep 27, 2006 at 04:09:18PM +0200, Zdenek Kotala wrote: > > Tom Lane napsal(a): > > >Zdenek Ko

Re: [HACKERS] horo(r)logy test fail on solaris (again and solved)

2006-09-27 Thread Kenneth Marshall
On Wed, Sep 27, 2006 at 04:09:18PM +0200, Zdenek Kotala wrote: > Tom Lane napsal(a): > >Zdenek Kotala <[EMAIL PROTECTED]> writes: > >>The problem was generated, because -fast option was set only for the > >>compiler and not for the linker. Linker takes wrong version of > >>libraries. If -fast i

Re: [HACKERS] horo(r)logy test fail on solaris (again and solved)

2006-09-27 Thread Zdenek Kotala
Tom Lane napsal(a): Zdenek Kotala <[EMAIL PROTECTED]> writes: The problem was generated, because -fast option was set only for the compiler and not for the linker. Linker takes wrong version of libraries. If -fast is set for both then horology test is OK, but question was if float optimaliza

Re: [HACKERS] horo(r)logy test fail on solaris (again and solved)

2006-09-27 Thread Tom Lane
Zdenek Kotala <[EMAIL PROTECTED]> writes: > The problem was generated, because -fast option was set only for the > compiler and not for the linker. Linker takes wrong version of > libraries. If -fast is set for both then horology test is OK, but > question was if float optimalization should ge

Re: [HACKERS] horo(r)logy test fail on solaris (again and solved)

2006-09-27 Thread Zdenek Kotala
Andrew Dunstan napsal(a): Tom Lane wrote: Zdenek Kotala <[EMAIL PROTECTED]> writes: But the question is if the "-fast" flag is good for postgres. The -fast flag sets "brutal" floating point optimization and some operation should have less precision. Is possible verify that floating point

Re: [HACKERS] horo(r)logy test fail on solaris (again and solved)

2006-09-27 Thread Zdenek Kotala
Josh Berkus napsal(a): Zdenek, Hmmm ... we're not using the -fast option for the standard PostgreSQL packages. Where did you start using it? Yes, I know. The -fast option generates architecture depending code and it is not possible use in common packages. I found out this option when I a

Re: [HACKERS] horo(r)logy test fail on solaris (again and solved)

2006-09-26 Thread Josh Berkus
Zdenek, Hmmm ... we're not using the -fast option for the standard PostgreSQL packages. Where did you start using it? -- --Josh Josh Berkus PostgreSQL @ Sun San Francisco ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will i

Re: [HACKERS] horo(r)logy test fail on solaris (again and

2006-09-26 Thread Luke Lonergan
Tom, On 9/26/06 9:15 AM, "Tom Lane" <[EMAIL PROTECTED]> wrote: > Andrew Dunstan <[EMAIL PROTECTED]> writes: >> ! | @ 6 years | @ 5 years 12 mons 5 days 6 hours > >> Doesn't this look odd regardless of what bad results come back from the >> FP library? > > It looks exact

Re: [HACKERS] horo(r)logy test fail on solaris (again and solved)

2006-09-26 Thread Josh Berkus
Zdenek, Zdenek Kotala <[EMAIL PROTECTED]> writes: But the question is if the "-fast" flag is good for postgres. The -fast flag sets "brutal" floating point optimization and some operation should have less precision. Is possible verify that floating point operation works well? That's a prett

Re: [HACKERS] horo(r)logy test fail on solaris (again and solved)

2006-09-26 Thread Tom Lane
Andrew Dunstan <[EMAIL PROTECTED]> writes: > ! | @ 6 years | @ 5 years 12 mons 5 days 6 hours > Doesn't this look odd regardless of what bad results come back from the > FP library? It looks exactly like the sort of platform-dependent rounding issue that Bruce and Michae

Re: [HACKERS] horo(r)logy test fail on solaris (again and solved)

2006-09-26 Thread Zdenek Kotala
Bruce Momjian napsal(a): Zdenek Kotala wrote: I tried regression test with Postgres Beta and horology test field. See attached log. It appears few month ago - see http://archives.postgresql.org/pgsql-ports/2006-06/msg4.php I used Sun Studio 11 with -fast flag and SPARC platform. Are you

Re: [HACKERS] horo(r)logy test fail on solaris (again and

2006-09-26 Thread Luke Lonergan
[HACKERS] horo(r)logy test fail on solaris (again and Zdenek Kotala wrote: > I tried regression test with Postgres Beta and horology test field. See > attached log. It appears few month ago - see > http://archives.postgresql.org/pgsql-ports/2006-06/msg4.php > I used Sun Studio 1

Re: [HACKERS] horo(r)logy test fail on solaris (again and solved)

2006-09-26 Thread Zdenek Kotala
Tom Lane napsal(a): Zdenek Kotala <[EMAIL PROTECTED]> writes: But the question is if the "-fast" flag is good for postgres. The -fast flag sets "brutal" floating point optimization and some operation should have less precision. Is possible verify that floating point operation works well? Tha

Re: [HACKERS] horo(r)logy test fail on solaris (again and solved)

2006-09-26 Thread Andrew Dunstan
Tom Lane wrote: Zdenek Kotala <[EMAIL PROTECTED]> writes: But the question is if the "-fast" flag is good for postgres. The -fast flag sets "brutal" floating point optimization and some operation should have less precision. Is possible verify that floating point operation works well?

Re: [HACKERS] horo(r)logy test fail on solaris (again and

2006-09-26 Thread Bruce Momjian
Zdenek Kotala wrote: > I tried regression test with Postgres Beta and horology test field. See > attached log. It appears few month ago - see > http://archives.postgresql.org/pgsql-ports/2006-06/msg4.php > I used Sun Studio 11 with -fast flag and SPARC platform. Are you looking for ways to c

Re: [HACKERS] horo(r)logy test fail on solaris (again and solved)

2006-09-26 Thread Tom Lane
Zdenek Kotala <[EMAIL PROTECTED]> writes: > But the question is if the "-fast" flag is good for postgres. The -fast > flag sets "brutal" floating point optimization and some operation should > have less precision. Is possible verify that floating point operation > works well? That's a pretty go

[HACKERS] horo(r)logy test fail on solaris (again and solved)

2006-09-26 Thread Zdenek Kotala
I tried regression test with Postgres Beta and horology test field. See attached log. It appears few month ago - see http://archives.postgresql.org/pgsql-ports/2006-06/msg4.php I used Sun Studio 11 with -fast flag and SPARC platform. I played little bit with cc flags and following flags wo