Re: BUG #7598: Loss of view performance after dump/restore of the view definition

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #7598: Loss of view performance after dump/restore of the view definition
Дата
Msg-id 10398.1350315840@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: BUG #7598: Loss of view performance after dump/restore of the view definition  (Vaclav Juza <vaclav.juza@xitee.com>)
Ответы Re: BUG #7598: Loss of view performance after dump/restore of the view definition  (Vaclav Juza <vaclav.juza@xitee.com>)
Список pgsql-bugs
Дерево обсуждения 
Vaclav Juza <vaclav.juza@xitee.com> writes:
> I have modified the test case (it is more similar to the real-word
> query), so that now it is slower on 9.2.1 than on 9.1.4 (the version
> with the explicit cast):

FWIW, testing this on HEAD (with the patch I committed last week),
I get a plan that's about 10% faster than 9.1; or if I disable
index-only scans for a more level playing field, it's just about
equivalent to 9.1.

            regards, tom lane

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

Предыдущее
От: seancompusult
Дата:
Сообщение: Re: BUG #7577: JDBC Driver - Compiled with Java 7
Следующее
От: webmaster@dhs-club.com
Дата:
Сообщение: BUG #7604: adding criteria to a query against a view in 9.2 expands the results instead of constraining them