Received: from localhost (unknown [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id 9526C9F9A70
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Thu, 20 Sep 2007 17:32:27 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024)
	with ESMTP id 36291-03 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Thu, 20 Sep 2007 17:32:10 -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 20B1D9F992B
	for <pgsql-performance@postgresql.org>;
	Thu, 20 Sep 2007 17:32:11 -0300 (ADT)
Received: from isper.nabble.com ([192.168.236.156])
	by kuber.nabble.com with esmtp (Exim 4.63)
	(envelope-from <lists@nabble.com>) id 1IYSgx-0004Dy-Me
	for pgsql-performance@postgresql.org; Thu, 20 Sep 2007 13:32:07 -0700
Message-ID: <12805270.post@talk.nabble.com>
Date: Thu, 20 Sep 2007 13:32:07 -0700 (PDT)
From: smiley2211 <smiley2211@yahoo.com>
To: pgsql-performance@postgresql.org
Subject: Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!!
In-Reply-To: <46F2CB62.4020409@mochima.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Nabble-From: smiley2211@yahoo.com
References: <12803859.post@talk.nabble.com> <46F2CB62.4020409@mochima.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=2.204 tagged_above=0 required=5 tests=AWL=0.092,
	BAYES_40=-0.185, FORGED_YAHOO_RCVD=2.297
X-Spam-Level: **
X-Archive-Number: 200709/337
X-Sequence-Number: 26882


No, I didn't UPGRADE it but that's what I inherited :( ...not sure of the
code page stuff because I am not the one who did the upgrade...I'm not sure
I know ENOUGH about POSTGRESQL to mess around with the codepage...

Yes, I use vacuum analyze...

Yes, I used the postgresql.conf of 7.4 and tried to match the 8.1.4 to
that...I didn't know where else to start...The users have been complaining
since DAY1 as I am told...

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#a12805270
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.