From: Scott Marlowe <scott.marlowe@gmail.com>
To: smiley2211 <smiley2211@yahoo.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!!
Date: Thu, 20 Sep 2007 16:25:19 -0500
Message-ID: <dcc563d10709201425o23647bc4v51b39bf05de0cc2f@mail.gmail.com> (raw)
In-Reply-To: <12805270.post@talk.nabble.com>
References: <12803859.post@talk.nabble.com>
<46F2CB62.4020409@mochima.com>
<12805270.post@talk.nabble.com>
On 9/20/07, smiley2211 <smiley2211@yahoo.com> wrote:
>
> 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...
OK, a few things you need to look into.
Do you have horrendous bloating in the db. run vacuum verbose on your
db and see what it says. You should probably turn on the autovacuum
daemon either way. If your database has gotten bloated you may need
to vacuum full / reindex to get your space back.
What queries are slow, specifically. you can set the server to log
long running servers in postgresql.conf. Find the longest running
ones and run them by hand with explain analyze at the front, like:
explain analyze select .....
lastly, run
vmstat 10
from the command line while the machine is running slow and see where
effort is going. I'm guessing you'll see a lot of id in there.
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: scott.marlowe@gmail.com, smiley2211@yahoo.com
Subject: Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!!
In-Reply-To: <dcc563d10709201425o23647bc4v51b39bf05de0cc2f@mail.gmail.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