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
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