PostgreSQL opens all the indexes of a relation for every Query during Planning Time? - Mailing list pgsql-hackers

From Meenatchi Sandanam
Subject PostgreSQL opens all the indexes of a relation for every Query during Planning Time?
Date
Msg-id CAJJu9dOQL5JKjv_XokA5r1fAw9Phsi67LFpcVpnF4vNj1Svong@mail.gmail.com
Whole thread Raw
Responses Re: PostgreSQL opens all the indexes of a relation for every Queryduring Planning Time?
List 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?

Attachment

pgsql-hackers by date:

Previous
From: Ashutosh Bapat
Date:
Subject: Re: [HACKERS] Partition-wise aggregation/grouping
Next
From: Arthur Zakirov
Date:
Subject: Re: pg_get_functiondef forgets about most GUC_LIST_INPUT GUCs