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

From: db(at)zigo(dot)dhs(dot)org
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-21 05:58:27
Message-ID: 55480.192.121.104.48.1190354307.squirrel@zigo.dhs.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Gregory Stark 2007-09-21 08:03:04 Re: Linux mis-reporting memory
Previous Message smiley2211 2007-09-21 03:25:44 Re: Upgraded from 7.4 to 8.1.4 QUERIES NOW SLOW!!!