PostgreSQL opens all the indexes of a relation for every Query during Planning Time?

Поиск
Список
Период
Сортировка
От Meenatchi Sandanam
Тема PostgreSQL opens all the indexes of a relation for every Query during Planning Time?
Дата
Msg-id CAJJu9dOQL5JKjv_XokA5r1fAw9Phsi67LFpcVpnF4vNj1Svong@mail.gmail.com
обсуждение исходный текст
Ответы Re: PostgreSQL opens all the indexes of a relation for every Queryduring Planning Time?  (Jason Petersen <jason@citusdata.com>)
Список pgsql-hackers
Дерево обсуждения
On checking PostgreSQL code, we see it opens all indexes of a relation for every query planning time as in the attachment. If that is the case, it might lead to Performance degradation for relations with many indexes. Is there any other better way to handle this like Scanning/Opening only the indexes related to columns specified in the query?

Вложения

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

Предыдущее
От: Ashutosh Bapat
Дата:
Сообщение: Re: [HACKERS] Partition-wise aggregation/grouping
Следующее
От: Arthur Zakirov
Дата:
Сообщение: Re: pg_get_functiondef forgets about most GUC_LIST_INPUT GUCs