Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id F0DD69FBAFA for ; Tue, 13 Feb 2007 16:10:00 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 69209-02 for ; Tue, 13 Feb 2007 16:10:00 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (Postfix) with SMTP id 7CBAC9FBAE9 for ; Tue, 13 Feb 2007 16:09:59 -0400 (AST) Received: (qmail invoked by alias); 13 Feb 2007 20:09:57 -0000 X-Provags-ID: V01U2FsdGVkX1+1dUJfuLm1CV2z2/7ONTYl4ZDEA700aiOe7Y6Abd LRfA== From: Peter Eisentraut To: pgsql-admin@postgresql.org Subject: Re: Question to safe way for minor update Date: Tue, 13 Feb 2007 21:11:23 +0100 User-Agent: KMail/1.9.5 Cc: "Thomas Papke" References: <1001305.61140.62.214.193.211.1171388243.squirrel@webmailer.hosteurope.de> In-Reply-To: <1001305.61140.62.214.193.211.1171388243.squirrel@webmailer.hosteurope.de> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200702132111.23707.peter_e@gmx.net> X-Y-GMX-Trusted: 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/181 X-Sequence-Number: 24646 Thomas Papke wrote: > 1. i am running a large postgres 8.1.4 database in production. What > is a good and safe way for an minor update to 8.1.8 (less downdown > and possible jump back option)? Using binary packages, install the new one over the old one, and if you don't like it, install the old one over the new one. > How riskful is an minor update for the data files? Not riskful. > 2. i am using two dualcore opterons with 8GB memory - if i am using > the CFLAGS="-O2" option for compile optimization --> is there any > real performance boost? I don't think anyone has ever seriously considered building with anything less than -O2 for anything but debugging purposes or coping with buggy compilers on rare architectures. In other words, there isn't any good reason not to do it. -- Peter Eisentraut http://developer.postgresql.org/~petere/