Re: new correlation metric

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: new correlation metric
Дата
Msg-id 14201.1225109887@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: new correlation metric  (Ron Mayer <rm_pg@cheapcomplexdevices.com>)
Ответы Re: new correlation metric  (Ron Mayer <rm_pg@cheapcomplexdevices.com>)
Список pgsql-hackers
Ron Mayer <rm_pg@cheapcomplexdevices.com> writes:
> ... I was somewhat surprised that the bitmap cost estimates didn't
> also change much.  Wouldn't the estimated # of data blocks
> read for the bitmap be roughly the same as for the index?

By definition, a bitmap scan's cost isn't affected by index order
correlation.
        regards, tom lane


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

Предыдущее
От: "Stephen R. van den Berg"
Дата:
Сообщение: Re: Full socket send buffer prevents cancel, timeout
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Parsing errors in pg_hba.conf