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

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 (view raw or flat)
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

pgsql-performance by date

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

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