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.
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 по дате отправления: