X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A9D3932A0DB for ; Fri, 22 Oct 2004 16:04:18 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 54015-09 for ; Fri, 22 Oct 2004 15:04:01 +0000 (GMT) Received: from neomail10.traderonline.com (email.traderonline.com [65.213.231.10]) by svr1.postgresql.org (Postfix) with ESMTP id 9E261329FB7 for ; Fri, 22 Oct 2004 16:04:06 +0100 (BST) Received: from [192.168.1.68] (64-139-89-109-ubr02b-epensb01-pa.hfc.comcastbusiness.net [64.139.89.109]) by neomail10.traderonline.com (8.12.10/8.12.8) with ESMTP id i9MF44IS024157 for ; Fri, 22 Oct 2004 11:04:04 -0400 Message-ID: <41792164.4040807@ptd.net> Date: Fri, 22 Oct 2004 11:04:04 -0400 From: Doug Y User-Agent: Mozilla Thunderbird 0.8 (Windows/20040913) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: RPM vs. Compile benefits? Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200410/308 X-Sequence-Number: 15301 Hello, I'm curious if I would see any specific benefit from compiling Postgres from scratch vs. using an RPM supplied by the distribution? We're currently using 7.4.2 from an RPM on SuSE 9.0 Pro. I'd guess RPMs are usually configured with the least common denominator in mind. All the software is stock on the system from SuSE. I'd guess I might see some overall system performance by a custom kernel compile (currently 2.6.4-52-smp), but thats not directly Postgres related. Hardware is dual Intel P3-1Ghz / 4G Ram / raid 0 if that makes any difference. Also, any significant reason to upgrade to 7.4.5? Obviously if compiling would be a boost, I'd also upgrade at the same time, but only unless I had a meaningful reason to compile in the first place. I've heard 7.4.2 has some problems with index bloat? How would that manifest itself? Thanks!