Re: Question about (probably wrong) index scan cost for conditional indexes

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Question about (probably wrong) index scan cost for conditional indexes
Дата
Msg-id 26128.1327278517@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Question about (probably wrong) index scan cost for conditional indexes  (Maxim Boguk <maxim.boguk@gmail.com>)
Ответы Re: Question about (probably wrong) index scan cost for conditional indexes  (Maxim Boguk <maxim.boguk@gmail.com>)
Список pgsql-general
Maxim Boguk <maxim.boguk@gmail.com> writes:
> But it seems that index scan cost for very narrow/selective conditional
> indexes is greatly overestimated at least in some cases.

I realized in connection with
http://archives.postgresql.org/pgsql-general/2012-01/msg00459.php
that btcostestimate is not correctly estimating numIndexTuples for
partial indexes.  But it's impossible to tell from this amount of
information whether you're seeing an effect of that, or something else.
Can you provide a self-contained test case?

            regards, tom lane

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

Предыдущее
От: panam
Дата:
Сообщение: Best way to create unique primary keys across schemas?
Следующее
От: David W Noon
Дата:
Сообщение: Re: hash options