Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 852121337B6E for ; Wed, 27 Oct 2010 12:19:51 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 22259-01 for ; Wed, 27 Oct 2010 15:19:44 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from manuel.natserv.net (p65-147.acedsl.com [66.114.65.147]) by mail.postgresql.org (Postfix) with ESMTP id 376071337B5B for ; Wed, 27 Oct 2010 12:19:44 -0300 (ADT) Received: from shelca (zoraida.natserv.net [66.114.65.147]) by manuel.natserv.net (Postfix) with ESMTP id AA302FA06; Wed, 27 Oct 2010 11:19:43 -0400 (EDT) References: Message-ID: X-Mailer: http://www.courier-mta.org/cone/ From: Francisco Reyes To: Tory M Blue Cc: pgsql-performance@postgresql.org Subject: Re: Running 9 in production? Sticking with 8.4.4 for a while? Date: Wed, 27 Oct 2010 11:19:43 -0400 Mime-Version: 1.0 Content-Type: text/plain; format=flowed; charset="US-ASCII" Content-Disposition: inline Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.59 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_RP_RNBL=1.31 X-Spam-Level: X-Archive-Number: 201010/473 X-Sequence-Number: 40891 Tory M Blue writes: > Just looking for 9.0 feedback (understand it's still quite new). Although not 9.0 feedback per se.. but something to consider... I am moving a number of machines from 8.1 to 8.4. We use a rolling procedure with a spare: machine A running 8.1 machine B is prepped with 8.4 change names and IPs keep old A for a bit just in case... The last replacement we noticed a big regression in performance. Upon inspection the machine we replaced was 3.7.. Both 8.X and 8.X have serious problems with a particualr query (dealing with it on performance now). So I guess what I am trying to say... you need to test with your own data set. That lone 8.3.7 machine was literally a fluke. We were going to move all 8.1 to 8.4.. but at one point did one in 8.3. If we had not done that we would not have noticed that both 8.1 and 8.4 have problems with some of our queries. I am even leaning now to have a lab with 8.3 for testing queries.