pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Bruce Momjian <pgman@candle.pha.pa.us>
To: Jeff <threshar@torgo.978.org>
Cc: Kenneth Marshall <ktm@is.rice.edu>
Cc: Neil Conway <neilc@samurai.com>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Sun performance - Major discovery!
Date: Thu, 9 Oct 2003 13:08:41 -0400 (EDT)
Message-ID: <200310091708.h99H8fY07153@candle.pha.pa.us> (raw)
In-Reply-To: <Pine.BSF.4.44.0310091302170.70613-100000@torgo.978.org>

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?

I have updated the Solaris FAQ:


5) How can I compile for optimum performance?

Try using the "-fast" compile flag.  The binaries might not be portable to
other Solaris systems, and you might need to compile everything that links
to PostgreSQL with "-fast", but PostgreSQL will run significantly faster,
50% faster on some tests.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073



view thread (48+ messages)  latest in thread

Message-ID: <200310091708.h99H8fY07153@candle.pha.pa.us>
Permalink:  ../200310091708.h99H8fY07153@candle.pha.pa.us/
Also on:    postgresql.org/message-id/200310091708.h99H8fY07153@candle.pha.pa.us

 · 

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 using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: pgman@candle.pha.pa.us, threshar@torgo.978.org, ktm@is.rice.edu, neilc@samurai.com
  Subject: Re: Sun performance - Major discovery!
  In-Reply-To: <200310091708.h99H8fY07153@candle.pha.pa.us>

* 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