X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 7F5CE9FA465 for ; Tue, 12 Sep 2006 12:38:56 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 95727-02 for ; Tue, 12 Sep 2006 15:38:39 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.191]) by postgresql.org (Postfix) with ESMTP id D93FC9FA2A1 for ; Tue, 12 Sep 2006 12:38:38 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id p77so1543186nfc for ; Tue, 12 Sep 2006 08:38:38 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=rJjUjk82XMeuCasCXl/o3mAM4sZfSkrYNsYsQb4w3tFRyGwZqPTcXjh6i+5rbBBNnoyJz+oh+KfhYlg/PYz13slmskgyLZMxhfYk+HKsec0hfxMZNItIiqDqJ3LoKZ+ldzrbDh6hyp/1/B0yM2fg5dDGGmDROxFj6Kj8mRHMD7k= Received: by 10.49.10.3 with SMTP id n3mr9768649nfi; Tue, 12 Sep 2006 08:38:38 -0700 (PDT) Received: by 10.78.45.4 with HTTP; Tue, 12 Sep 2006 08:38:37 -0700 (PDT) Message-ID: Date: Tue, 12 Sep 2006 11:38:38 -0400 From: "Merlin Moncure" To: "Scott Marlowe" Subject: Re: Performance problem with Sarge compared with Woody Cc: "=?ISO-8859-1?Q?Pi=F1eiro?=" , pgsql-performance@postgresql.org In-Reply-To: <1158071323.1854.29.camel@state.g2switchworks.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <1157998456.7540.15.camel@codfix.local.igalia.com> <1158012220.1854.10.camel@state.g2switchworks.com> <1158071323.1854.29.camel@state.g2switchworks.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200609/89 X-Sequence-Number: 20775 On 9/12/06, Scott Marlowe wrote: > On Mon, 2006-09-11 at 20:53, Merlin Moncure wrote: > > for 3 months I ran a 400M$ manufacturing company's erp off of a > > pre-beta 8.0 windows pg server converted from cobol using some hacked > > out c++ middleware. I remember having to change how the middleware > > handled transactions when Alvaro changed them to a checkpoint > > mechanism. I also remember being relieved when I no longer had to > > manually edit pg_config.h so nobody would notice they would notice > > they were running a beta version of postgresql had one of the > > technical people casually logged into psql. I scraped out almost > > completely unscathed except for a nasty crash due to low stack > > allocation of the compiler on windows. > > > > the point of all this? get onto a recent version of postgresql, what > > could possbily go wrong? > > You did notice I mentioned that it would only make sense if they weren't > going into production right away. I.e. develop the app while pgdg > develops the database, and release at about the same time. > > I wouldn't put 8.2 into production just yet, but if I had a launch date > of next spring, I'd certainly consider developing on it now. right, very good advice :) I was giving more of a "don't try this at home" type post. To the OP, though, I would advise that each version of PostgreSQL is much faster (sometimes, drastically so). Once in a while you get a query that you have to rethink but the engine improves with each release. merlin