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 9CF4AD1CCBE for ; Tue, 3 Feb 2004 23:01:50 +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 89888-02 for ; Tue, 3 Feb 2004 19:01:51 -0400 (AST) Received: from anchor-post-31.mail.demon.net (anchor-post-31.mail.demon.net [194.217.242.89]) by svr1.postgresql.org (Postfix) with ESMTP id 8627CD1CCA8 for ; Tue, 3 Feb 2004 19:01:48 -0400 (AST) Received: from tmsl-adsl.demon.co.uk ([80.177.114.181] helo=bacon.tmsl.demon.co.uk) by anchor-post-31.mail.demon.net with esmtp (Exim 3.35 #1) id 1Ao9YE-0007Gu-0V for pgsql-performance@postgresql.org; Tue, 03 Feb 2004 23:01:50 +0000 Date: Tue, 3 Feb 2004 23:01:47 +0000 From: Paul Thomas To: "pgsql-performance @ postgresql . org" Subject: Re: Compile Vs RPMs Message-ID: <20040203230147.A23912@bacon> References: <4BAFBB6B9CC46F41B2AD7D9F4BBAF785097FB2@vt-pe2550-001.vantage.vantage.com> Mime-Version: 1.0 Content-Type: text/plain; format=flowed; charset=ISO-8859-1 In-Reply-To: <4BAFBB6B9CC46F41B2AD7D9F4BBAF785097FB2@vt-pe2550-001.vantage.vantage.com>; from adave@vantage.com on Tue, Feb 03, 2004 at 20:58:22 +0000 X-Mailer: Balsa 1.2.3 Lines: 24 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/59 X-Sequence-Number: 5583 On 03/02/2004 20:58 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). Very unlikely I would have thought. Databases tend to speed-limited by I-O performance and the amount of RAM available for caching etc. Having said that, I've only got one machine (the laptop on which I'm writing this email) which has still got its rpm binaries. My other machines have all been upgraded from source. -- Paul Thomas +------------------------------+---------------------------------------------+ | Thomas Micro Systems Limited | Software Solutions for the Smaller Business | | Computer Consultants | http://www.thomas-micro-systems-ltd.co.uk | +------------------------------+---------------------------------------------+