Re: limit in subquery causes poor selectivity estimation

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: limit in subquery causes poor selectivity estimation
Дата
Msg-id 21748.1314814378@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: limit in subquery causes poor selectivity estimation  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> On Wed, Aug 31, 2011 at 6:22 AM, Peter Eisentraut <peter_e@gmx.net> wrote:
>> I liked the old one better. ;-)

> AFAICS, those plans are identical, except for a minor difference in
> the cost of scanning test2.

The point is that the estimate of the result size is worse in 8.4.8.

I am not, however, convinced that 8.4.7 was actually smarter ... it
may have been getting the right answer for the wrong reason.
        regards, tom lane


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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: limit in subquery causes poor selectivity estimation
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [GENERAL] pg_upgrade problem