From: smiley2211 <smiley2211@yahoo.com>
To: pgsql-performance@postgresql.org
Subject: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!!
Date: Thu, 20 Sep 2007 12:10:23 -0700 (PDT)
Message-ID: <12803859.post@talk.nabble.com> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: smiley2211@yahoo.com
Subject: Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!!
In-Reply-To: <12803859.post@talk.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox