X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id EF336D1D17E for ; Tue, 3 Feb 2004 22:43:15 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 83784-02 for ; Tue, 3 Feb 2004 18:43:12 -0400 (AST) Received: from internet.potentialtech.com (h-66-167-251-6.PHLAPAFG.covad.net [66.167.251.6]) by svr1.postgresql.org (Postfix) with ESMTP id 2FF43D1C7F7 for ; Tue, 3 Feb 2004 18:43:09 -0400 (AST) Received: from potentialtech.com (pa-plum1c-102.pit.adelphia.net [24.53.179.102]) by internet.potentialtech.com (Postfix) with ESMTP id D7A2769A4B; Tue, 3 Feb 2004 17:43:10 -0500 (EST) Message-ID: <402023FC.7000007@potentialtech.com> Date: Tue, 03 Feb 2004 17:43:08 -0500 From: Bill Moran User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.4) Gecko/20031005 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Anjan Dave Cc: pgsql-performance@postgresql.org Subject: Re: Compile Vs RPMs References: <4BAFBB6B9CC46F41B2AD7D9F4BBAF785097FB2@vt-pe2550-001.vantage.vantage.com> In-Reply-To: <4BAFBB6B9CC46F41B2AD7D9F4BBAF785097FB2@vt-pe2550-001.vantage.vantage.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/58 X-Sequence-Number: 5582 Anjan Dave wrote: > Hello, > > 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). "significant" is a relative term. 1% can be significant under the proper circumstances ... http://www.potentialtech.com/wmoran/source.php The information isn't specific to Postgres, and the results aren't really conclusive, but hopefully it helps. I really think that if someone would actually test this with Postgres and post the results, it would be very beneficial to the community. I have it on my list of things to do, but it's unlikely to get done in the first quarter the way things are going. -- Bill Moran Potential Technologies http://www.potentialtech.com