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 2914FD1C512 for ; Wed, 4 Feb 2004 00:21:30 +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 12756-09 for ; Tue, 3 Feb 2004 20:21:31 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 409EED1B44D for ; Tue, 3 Feb 2004 20:21:28 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id i140LRsv084968 for ; Wed, 4 Feb 2004 00:21:27 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i140AQjj082895 for pgsql-performance@postgresql.org; Wed, 4 Feb 2004 00:10:26 GMT From: Christopher Browne X-Newsgroups: comp.databases.postgresql.performance Subject: Re: Compile Vs RPMs Date: Tue, 03 Feb 2004 18:43:08 -0500 Organization: Hub.Org Networking Services Lines: 30 Message-ID: <60smhrk9v7.fsf@dev6.int.libertyrms.info> References: <4BAFBB6B9CC46F41B2AD7D9F4BBAF785097FB2@vt-pe2550-001.vantage.vantage.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org User-Agent: Gnus/5.110002 (No Gnus v0.2) XEmacs/21.4 (Reasonable Discussion, linux) Cancel-Lock: sha1:CFNZzrflupejaiUcT0p9nHRBfOE= To: pgsql-performance@postgresql.org X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/61 X-Sequence-Number: 5585 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") Christopher Browne (416) 646 3304 x124 (land)