Re: index paths and enable_indexscan

Поиск
Список
Период
Сортировка
От Richard Guo
Тема Re: index paths and enable_indexscan
Дата
Msg-id CAMbWs4-+zTPg8rQUMWwfSpC_heYVsUhHcc7Sf9fvCWKSynpWvA@mail.gmail.com
обсуждение исходный текст
Ответ на index paths and enable_indexscan  (Amit Langote <amitlangote09@gmail.com>)
Ответы Re: index paths and enable_indexscan
Список pgsql-hackers

On Tue, Apr 14, 2020 at 2:44 PM Amit Langote <amitlangote09@gmail.com> wrote:
Hi,

Maybe I am missing something obvious, but is it intentional that
enable_indexscan is checked by cost_index(), that is, *after* creating
an index path?  I was expecting that if enable_indexscan is off, then
no index paths would be generated to begin with, because I thought
they are optional.

I think the cost estimate of index paths is the same as other paths on
that setting enable_xxx to off only adds a penalty factor (disable_cost)
to the path's cost. The path would be still generated and compete with
other paths in add_path().

Thanks
Richard 

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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Incremental sorts and EXEC_FLAG_REWIND
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: pgsql: Improve handling of parameter differences in physicalreplicatio