Re: Sun performance - Major discovery!

From: Jeff <threshar(at)torgo(dot)978(dot)org>
To: Neil Conway <neilc(at)samurai(dot)com>
Cc: PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Sun performance - Major discovery!
Date: 2003-10-08 18:11:23
Message-ID: Pine.BSF.4.44.0310081408370.64781-100000@torgo.978.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers 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(at)jefftrout(dot)com>
http://www.jefftrout.com/
http://www.stuarthamm.net/

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2003-10-08 18:15:58 Re: PostgreSQL vs. MySQL
Previous Message Manfred Koizar 2003-10-08 18:11:08 Re: [HACKERS] Cannot dump/restore text value \N

Browse pgsql-performance by date

  From Date Subject
Next Message Bruce Momjian 2003-10-08 18:15:58 Re: PostgreSQL vs. MySQL
Previous Message Josh Berkus 2003-10-08 18:05:47 Re: PostgreSQL vs. MySQL