Re: ugly query slower in 7.3, even slower after vacuum full analyze

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: ugly query slower in 7.3, even slower after vacuum full analyze
Дата
Msg-id 19626.1053619357@sss.pgh.pa.us
обсуждение исходный текст
Ответ на ugly query slower in 7.3, even slower after vacuum full analyze  ("SZŰCS Gábor" <surrano@mailbox.hu>)
Список pgsql-performance
Дерево обсуждения 
"=?iso-8859-2?B?U1rbQ1MgR+Fib3I=?=" <surrano@mailbox.hu> writes:
> This is a rather nasty query, built up from several parameters, and it
> proved to be 7--15 times slower in 7.3 than in 7.2.

I think you are running into the same subselect-in-targetlist
shortcoming as Eugene Fokin did:
http://archives.postgresql.org/pgsql-performance/2003-05/msg00204.php

            regards, tom lane

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

Предыдущее
От: "SZŰCS Gábor"
Дата:
Сообщение: ugly query slower in 7.3, even slower after vacuum full analyze
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: ugly query slower in 7.3, even slower after vacuum full analyze