Re: Index creation

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Index creation
Дата
Msg-id CAKFQuwY0kww1BGk4-KhiLZRq=v1ygCUnav_QGo27QfAj1kFreA@mail.gmail.com
обсуждение исходный текст
Ответ на Index creation  (Дмитрий Иванов <firstdismay@gmail.com>)
Ответы Re: Index creation  (Дмитрий Иванов <firstdismay@gmail.com>)
Список pgsql-general
Дерево обсуждения
On Sun, Jun 19, 2022 at 12:06 PM Дмитрий Иванов <firstdismay@gmail.com> wrote:
Good afternoon.
I have a query parser question. If there are two kinds of queries using an indexed field. In this case, one view is limited to this field, the second one uses a number of fields included in the index by the include directive. It makes sense to have two indexes, lightweight and containing include. Or will the plan rely on the nearest suitable index without considering its weight?


The system should avoid the larger sized index unless it will sufficiently benefit from the Index Only Scan that such a larger covering index is supposed to facilitate.

David J.

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

Предыдущее
От: Дмитрий Иванов
Дата:
Сообщение: Index creation
Следующее
От: Bryn Llewellyn
Дата:
Сообщение: Outer joins and NULLs (old subject "ERROR: failed to find conversion function from key_vals_nn to record[]")