Re: 8.3devel slower than 8.2 under read-only load

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 8.3devel slower than 8.2 under read-only load
Дата
Msg-id 26771.1195710295@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: 8.3devel slower than 8.2 under read-only load  ("Guillaume Smet" <guillaume.smet@gmail.com>)
Ответы Re: 8.3devel slower than 8.2 under read-only load  ("Guillaume Smet" <guillaume.smet@gmail.com>)
Список pgsql-hackers
"Guillaume Smet" <guillaume.smet@gmail.com> writes:
> I'm not saying my benchmark is perfectly relevant: I made it
> excessively simple on purpose. I just see a general slow down which is
> quite consistent accross all the tests I did (with pgbench or the
> application) and I'd really like to know if it's just my case on this
> particular box or something more general.

Are you examining only "trivial" queries?  I've been able to identify a
couple of new planner hotspots that could explain some slowdown if the
planning time is material compared to the execution time.  If you're
seeing a slowdown on queries that run for awhile, that would be
something else ...
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Jonah H. Harris"
Дата:
Сообщение: Re: 8.3devel slower than 8.2 under read-only load
Следующее
От: cinu
Дата:
Сообщение: run_build.pl ~ By Andrew Dunstan