Re: Identical query slower on 8.4 vs 8.3

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Patrick Donlin" <pdonlin(at)oaisd(dot)org>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Identical query slower on 8.4 vs 8.3
Date: 2010-07-15 14:55:19
Message-ID: 4C3EDB070200002500033621@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Patrick Donlin <pdonlin(at)oaisd(dot)org> wrote:

> Anyone have any ideas on where I should start looking to figure
> this out?

You're going to want to run EXPLAIN ANALYZE for the slow query on
both servers. If you want the rest of us to be able to contribute
ideas, we'll need a little more information -- please read this
page:

http://wiki.postgresql.org/wiki/SlowQueryQuestions

> I didn't perform any special steps when moving to v8.4, I just did
> a pg_dump from the 8.3 server and restored it on the new 8.4
> servers.

A database VACUUM ANALYZE by a superuser is a good idea; otherwise
that's fine technique.

-Kevin

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Patrick Donlin 2010-07-15 15:12:53 Re: Identical query slower on 8.4 vs 8.3
Previous Message Thom Brown 2010-07-15 14:50:29 Re: Identical query slower on 8.4 vs 8.3