Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 9AB039F9AC8 for ; Thu, 20 Sep 2007 16:10:39 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 65646-03 for ; Thu, 20 Sep 2007 16:10:21 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from kuber.nabble.com (kuber.nabble.com [216.139.236.158]) by postgresql.org (Postfix) with ESMTP id 3493A9F9B39 for ; Thu, 20 Sep 2007 16:10:25 -0300 (ADT) Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1IYRPr-0001hj-IK for pgsql-performance@postgresql.org; Thu, 20 Sep 2007 12:10:23 -0700 Message-ID: <12803859.post@talk.nabble.com> Date: Thu, 20 Sep 2007 12:10:23 -0700 (PDT) From: smiley2211 To: pgsql-performance@postgresql.org Subject: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: smiley2211@yahoo.com X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.049 tagged_above=0 required=5 tests=AWL=1.351, BAYES_00=-2.599, FORGED_YAHOO_RCVD=2.297 X-Spam-Level: * X-Archive-Number: 200709/334 X-Sequence-Number: 26879 Hello all, Old servers that housed 7.4 performed better than 8.1.4 version...are there any MAJOR performance hits with this version??? I set the postgresql.conf setting to equal that of 7.4 and queries still run SLOW on 8.1.4... I have perform maintenance tonight on the 8.1.4 server - any ideas what actions I should take??? default stats set to 50 (in postgresql.conf) 1) Restart instance 2) Dump \ reload database 3) vacuum analyze 4) rebuild index database I keep doing these same steps and nothing seems to work...I've read where some are saying to VACUUM several times - then reindex (???) Can someone tell me what they do during a NORMAL maintenance window on their servers??? All this is NEW to me. Thanks, Michelle. -- View this message in context: http://www.nabble.com/Upgraded-from-7.4-to-8.1.4-QUERIES-NOW-SLOW%21%21%21-tf4489502.html#a12803859 Sent from the PostgreSQL - performance mailing list archive at Nabble.com.