Re: Apparently useless bitmap scans

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Apparently useless bitmap scans
Дата
Msg-id 27552.1178726173@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Apparently useless bitmap scans  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-performance
Peter Eisentraut <peter_e@gmx.net> writes:
> OK, upgrading to 8.2.4 fixes this odd plan choice.  The query does run
> a bit faster too, but the cost estimate has actually gone up!

Yeah, because the former code was making an unrealistically small
estimate of the number of tuples found by BitmapAnd (due to
double-counting the selectivities of redundant indexes), and of course
that means a smaller estimate of the cost to fetch them in the bitmap
heap scan.

            regards, tom lane

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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Apparently useless bitmap scans
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Nested loops overpriced