Re: Sun performance - Major discovery! - Mailing list pgsql-performance

From Jeff
Subject Re: Sun performance - Major discovery!
Date
Msg-id Pine.BSF.4.44.0310081408370.64781-100000@torgo.978.org
Whole thread Raw
In response to Re: Sun performance - Major discovery!  (Neil Conway <neilc@samurai.com>)
Responses Re: Sun performance - Major discovery!
Re: Sun performance - Major discovery!
List pgsql-performance
On Wed, 8 Oct 2003, Neil Conway wrote:

>
> What CFLAGS does configure pick for gcc? From
> src/backend/template/solaris, I'd guess it's not enabling any
> optimization. Is that the case? If so, some gcc numbers with -O and -O2
> would be useful.
>

I can't believe I didn't think of this before! heh.
Turns out gcc was getting nothing for flags.

I added -O2 to CFLAGS and my 60 seconds went down to 21.  A rather mild
improvment huh?

I did a few more tests and suncc still beats it out - but not by too much
now (Not enought to justify buying a license just for compiling pg)

I'll go run the regression test suite with my gcc -O2 pg and the suncc pg.
See if they pass the test.

If they do we should consider adding -O2 and -fast to the CFLAGS.

--
Jeff Trout <jeff@jefftrout.com>
http://www.jefftrout.com/
http://www.stuarthamm.net/



pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: PostgreSQL vs. MySQL
Next
From: Bruce Momjian
Date:
Subject: Re: PostgreSQL vs. MySQL