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 192E7EAED94 for ; Fri, 22 Oct 2004 19:30:58 +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 12282-07 for ; Fri, 22 Oct 2004 18:30:55 +0000 (GMT) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id 97543EAEDB7 for ; Fri, 22 Oct 2004 19:30:45 +0100 (BST) Received: (qmail 30772 invoked by uid 500); 22 Oct 2004 18:41:49 -0000 Date: Fri, 22 Oct 2004 13:41:49 -0500 From: Bruno Wolff III To: Doug Y Cc: pgsql-admin@postgresql.org Subject: Re: RPM vs. Compile benefits? Message-ID: <20041022184149.GA25599@wolff.to> Mail-Followup-To: Doug Y , pgsql-admin@postgresql.org References: <41792164.4040807@ptd.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <41792164.4040807@ptd.net> User-Agent: Mutt/1.5.6i 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/311 X-Sequence-Number: 15304 On Fri, Oct 22, 2004 at 11:04:04 -0400, Doug Y wrote: > 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. The rpms prossibly include some stuff that is not part of the core project but are still things you want to have. Figuring out what you want and pulling it all together may be more work than you want to do. Also rembember that if you change build options you should do a dump and restore even when upgrading between minor releases in the same series (unless you know for sure the changed build options won't change the disk layout). > 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? I think the answer to this is yes you should upgrade. But you can look at the release notes and decide for yourself.