Re: Identical query slower on 8.4 vs 8.3

От: Alvaro Herrera
Тема: Re: Identical query slower on 8.4 vs 8.3
Дата: ,
Msg-id: 1279207110-sup-2392@alvh.no-ip.org
(см: обсуждение, исходный текст)
Ответ на: 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", )

Excerpts from Patrick Donlin's message of jue jul 15 11:12:53 -0400 2010:
> I'll read over that wiki entry, but for now here is the EXPLAIN ANALYZE output assuming I did it correctly. I have
runvacuumdb --full --analyze, it actually runs as a nightly cron job.  

These plans seem identical (though the fact that the leading whitespace
was trimmed means it's untrustworthy -- please in the future send them
as text attachments instead so that your mailer doesn't interfere with
formatting).  The 8.4 plan is even a full second faster, according to
the "total runtime" line.

The slowness could've been caused by caching effects ...


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

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