Re: [9.2devel] why it doesn't do index scan only?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [9.2devel] why it doesn't do index scan only?
Дата
Msg-id 11589.1318092466@sss.pgh.pa.us
обсуждение исходный текст
Ответ на [9.2devel] why it doesn't do index scan only?  (hubert depesz lubaczewski <depesz@depesz.com>)
Ответы Re: [9.2devel] why it doesn't do index scan only?
Re: [9.2devel] why it doesn't do index scan only?
Список pgsql-general
hubert depesz lubaczewski <depesz@depesz.com> writes:
> it is selecting 20 rows out of 30 million. why is it:
> 1. not using index only scan
> 2. not using even normal index scan?

It thinks the bitmap scan is cheaper.  Whether that's true or not is not
very clear, but nobody is claiming that the costing of index-only scans
is accurate yet.

            regards, tom lane

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

Предыдущее
От: hubert depesz lubaczewski
Дата:
Сообщение: [9.2devel] why it doesn't do index scan only?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [9.2devel] why it doesn't do index scan only?