Re: BUG #14438: Wrong row count in the join plan with unique index scan

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #14438: Wrong row count in the join plan with unique index scan
Дата
Msg-id 11935.1480460865@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #14438: Wrong row count in the join plan with unique index scan  (nikolay.nikitin@infowatch.com)
Ответы Re: BUG #14438: Wrong row count in the join plan with unique index scan
Список pgsql-bugs
nikolay.nikitin@infowatch.com writes:
> I execute select with "in" condition on the empty table.
> This select works with wrong plan.
> I think the wrong plan is chosen becose the postgres optimizer incorrectly
> calculates row count in the right plan.

I've pushed a patch that should improve matters for such cases.
Thanks for the report!

            regards, tom lane

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