From: Christopher Browne <cbbrowne@libertyrms.info>
To: pgsql-performance@postgresql.org
Subject: Re: Compile Vs RPMs
Date: Tue, 03 Feb 2004 18:43:08 -0500
Message-ID: <60smhrk9v7.fsf@dev6.int.libertyrms.info> (raw)
References: <4BAFBB6B9CC46F41B2AD7D9F4BBAF785097FB2@vt-pe2550-001.vantage.vantage.com>
adave@vantage.com ("Anjan Dave") writes:
> I would like to know whether there are any significant performance
> advantages of compiling (say, 7.4) on your platform (being RH7.3, 8,
> and 9.0, and Fedora especially) versus getting the relevant binaries
> (rpm) from the postgresql site? Hardware is Intel XEON (various
> speeds, upto 2.8GHz, single/dual/quad configuration).
Some Linux distribution makers make grand claims of such advantages,
but it is not evident that this is much better than superstition.
You are certainly NOT going to see GCC generating MMX code
automagically that would lead to PostgreSQL becoming 8 times faster.
Indeed, in database work, it is quite likely that you will find things
to be largely I/O bound, with CPU usage being a very much secondary
factor.
I did some relative benchmarking between compiling PostgreSQL on GCC
versus IBM's PPC compilers a while back; did not see differences that
could be _clearly_ discerned as separate from "observational noise."
You should expect find that adding RAM, or adding a better disk
controller would provide discernable differences in performance. It
is much less clear that custom compiling will have any substantial
effect on I/O-bound processing.
--
output = reverse("ofni.smrytrebil" "@" "enworbbc")
<http://dev6.int.libertyrms.com/;
Christopher Browne
(416) 646 3304 x124 (land)
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: cbbrowne@libertyrms.info
Subject: Re: Compile Vs RPMs
In-Reply-To: <60smhrk9v7.fsf@dev6.int.libertyrms.info>
* 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