Re: Sun performance - Major discovery!

From: Kenneth Marshall <ktm(at)it(dot)is(dot)rice(dot)edu>
To: Jeff <threshar(at)torgo(dot)978(dot)org>
Cc: Kenneth Marshall <ktm(at)is(dot)rice(dot)edu>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Neil Conway <neilc(at)samurai(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Sun performance - Major discovery!
Date: 2003-10-09 20:31:24
Message-ID: 20031009203124.GB20719@it.is.rice.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

I would use a simple -xO2 or -xO3 instead as the default with
an -fsimple=2.

--Ken

-x02 -xbuiltin=%all
On Thu, Oct 09, 2003 at 01:04:23PM -0400, Jeff wrote:
> On Thu, 9 Oct 2003, Kenneth Marshall wrote:
>
> > Jeff,
> >
> > My first concern with the -fast option is that it makes an executable
> > that is specific for the platform on which the compilation is run
> > unless other flags are given. My second concern is the effect it has
> > on IEEE floating point behavior w.r.t. rounding, error handling, ....
> > And my third concern is that if you use -fast, all other code must
> > be compiled and linked with the -fast option for correct operation,
> > this includes any functional languages such as perl, python, R,...
> > That is a pretty big requirement for a default compilation flag.
> >
> > Ken Marshall
> >
>
> So you think we should leave PG alone and let it run horrifically slowly?
> Do you have a better idea of how to do this?
>
> And do you have evidence apps compiled with -fast linked to non -fast
> (or gcc compiled) have problems?
>
>
> --
> Jeff Trout <jeff(at)jefftrout(dot)com>
> http://www.jefftrout.com/
> http://www.stuarthamm.net/
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Stark 2003-10-09 23:07:00 Re: Speeding up Aggregates
Previous Message David Griffiths 2003-10-09 20:26:22 Re: OFFTOPIC: PostgreSQL vs MySQL