Re: Identical query slower on 8.4 vs 8.3

От: Kevin Grittner
Тема: Re: Identical query slower on 8.4 vs 8.3
Дата: ,
Msg-id: 4C3EDB070200002500033621@gw.wicourts.gov
(см: обсуждение, исходный текст)
Ответ на: Identical query slower on 8.4 vs 8.3  (Patrick Donlin)
Ответы: Re: Identical query slower on 8.4 vs 8.3  (Patrick Donlin)
Список: pgsql-performance

Скрыть дерево обсуждения

Identical query slower on 8.4 vs 8.3  (Patrick Donlin, )
 Re: Identical query slower on 8.4 vs 8.3  (Thom Brown, )
 Re: Identical query slower on 8.4 vs 8.3  ("Kevin Grittner", )
  Re: Identical query slower on 8.4 vs 8.3  (Patrick Donlin, )
   Re: Identical query slower on 8.4 vs 8.3  (Alvaro Herrera, )
   Re: Identical query slower on 8.4 vs 8.3  (Andy Colson, )
   Re: Identical query slower on 8.4 vs 8.3  ("Kevin Grittner", )
   Re: Identical query slower on 8.4 vs 8.3  (Merlin Moncure, )
    Re: Identical query slower on 8.4 vs 8.3  (Patrick Donlin, )
   Re: Identical query slower on 8.4 vs 8.3  ("Igor Neyman", )
  Re: Identical query slower on 8.4 vs 8.3  (, )
 Re: Identical query slower on 8.4 vs 8.3  (Jon Nelson, )
 Re: Identical query slower on 8.4 vs 8.3  ("Joshua D. Drake", )
 Re: Identical query slower on 8.4 vs 8.3  ("Joshua D. Drake", )

Patrick Donlin <> 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


В списке pgsql-performance по дате сообщения:

От: Patrick Donlin
Дата:
Сообщение: Re: Identical query slower on 8.4 vs 8.3
От: Scott Carey
Дата:
Сообщение: Re: performance on new linux box