Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 45DE79F9EEF for ; Fri, 21 Sep 2007 02:58:32 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 64261-10 for ; Fri, 21 Sep 2007 02:58:27 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from proxy2.bredband.net (proxy2.bredband.net [195.54.101.72]) by postgresql.org (Postfix) with ESMTP id E5B269F9D57 for ; Fri, 21 Sep 2007 02:58:28 -0300 (ADT) Received: from zigo.dhs.org (83.227.204.174) by proxy2.bredband.net (7.3.127) id 46F02E7400179FA8; Fri, 21 Sep 2007 07:58:27 +0200 Received: from zigo.dhs.org (zigo [127.0.0.1]) by zigo.dhs.org (Postfix) with ESMTP id 272E98640; Fri, 21 Sep 2007 07:58:27 +0200 (CEST) Received: from 192.121.104.48 (SquirrelMail authenticated user db) by zigo.dhs.org with HTTP; Fri, 21 Sep 2007 07:58:27 +0200 (CEST) Message-ID: <55480.192.121.104.48.1190354307.squirrel@zigo.dhs.org> In-Reply-To: <12803859.post@talk.nabble.com> References: <12803859.post@talk.nabble.com> Date: Fri, 21 Sep 2007 07:58:27 +0200 (CEST) Subject: Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!! From: db@zigo.dhs.org To: "smiley2211" Cc: pgsql-performance@postgresql.org User-Agent: SquirrelMail/1.4.8 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) Importance: Normal X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/347 X-Sequence-Number: 26892 > 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... We need to find a specific query that is slow now that was fast before, and see the EXPLAIN ANALYZE of that query. If you have the old server still around then showing the EXPLAIN ANALYZE of the same query on that server would be a lot of help. /Dennis