Re: 7.3 vs 7.2 - different query plan, bad performance

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: 7.3 vs 7.2 - different query plan, bad performance
Дата
Msg-id 2680.1055773063@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: 7.3 vs 7.2 - different query plan, bad performance  (Ryszard Lach <siaco@autograf.pl>)
Список pgsql-performance
Ryszard Lach <siaco@autograf.pl> writes:
> The point is, that my tables (and queries) are a 'little' bit more
> complicated and I wanted to give as simple example as I could. I think
> that problem is that subselects are _much_slower_ executed in 7.3 than
> in 7.2, just as someone already wrote here.

No, the problem is that 7.3 fails to notice that it doesn't really need
to execute the subselect at all.  This is the price we paid for being
sure that a post-release bug fix wouldn't break anything more serious.
There is a better fix in place for 7.4.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Partial index where clause not filtering through
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: A bit OT- RE: Re-ordering .CONF params ... questions for this list