Skip site navigation (1) Skip section navigation (2)

Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!!

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: smiley2211 <smiley2211(at)yahoo(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!!
Date: 2007-09-20 21:25:19
Message-ID: dcc563d10709201425o23647bc4v51b39bf05de0cc2f@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-performance
On 9/20/07, smiley2211 <smiley2211(at)yahoo(dot)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.

In response to

Responses

pgsql-performance by date

Next:From: Scott MarloweDate: 2007-09-20 21:25:42
Subject: Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!!
Previous:From: smiley2211Date: 2007-09-20 20:32:07
Subject: Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!!

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group