pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Andrew Dunstan <andrew@dunslane.net>
To: Postgresql Hackers <pgsql-hackers@postgresql.org>
Subject: Re: [PERFORM] Sun performance - Major discovery!
Date: Wed, 08 Oct 2003 14:50:24 -0400
Message-ID: <3F845C70.8060108@dunslane.net> (raw)
In-Reply-To: <200310081831.h98IVT919657@candle.pha.pa.us>
References: <200310081831.h98IVT919657@candle.pha.pa.us>

Bruce Momjian wrote:

>Jeff wrote:
>  
>
>>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.
>>    
>>
>
>[ CC added for hackers.]
>
>Well, this is really embarassing.  I can't imagine why we would not set
>at least -O on all platforms.  Looking at the template files, I see
>these have no optimization set:
>	
>	darwin
>	dgux
>	freebsd (non-alpha)
>	irix5
>	nextstep
>	osf (gcc)
>	qnx4
>	solaris
>	sunos4
>	svr4
>	ultrix4
>
>I thought we used to have code that did -O for any platforms that set no
>cflags, but I don't see that around anywhere.  I recommend adding -O2,
>or at leaset -O to all these platforms --- we can then use platform
>testing to make sure they are working.
>
>  
>
Actually, I would not be surprised to see gains on Solaris/SPARC from 
-O3 with gcc, which enables inlining and register-renaming, although 
this does make debugging pretty much impossible.

worth testing at least (but I no longer have access to a Solaris machine).

cheers

andrew




view thread (48+ messages)  latest in thread

Message-ID: <3F845C70.8060108@dunslane.net>
Permalink:  ../3F845C70.8060108@dunslane.net/
Also on:    postgresql.org/message-id/3F845C70.8060108@dunslane.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: andrew@dunslane.net, pgsql-hackers@postgresql.org
  Subject: Re: [PERFORM] Sun performance - Major discovery!
  In-Reply-To: <3F845C70.8060108@dunslane.net>
  References: <200310081831.h98IVT919657@candle.pha.pa.us> <3F845C70.8060108@dunslane.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox