| 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: | Whole Thread | Raw Message | 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/
| 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 |
| 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 |