Re: PostgreSQL opens all the indexes of a relation for every Queryduring Planning Time?
От
Meenatchi Sandanam
Тема
Re: PostgreSQL opens all the indexes of a relation for every Queryduring Planning Time?
Дата
Msg-id
CAJJu9dN=omj9r_eAWUNPP2zKMXSduVcjisbDoX=PuVuGCRfwpQ@mail.gmail.com
Ответ на
Re: PostgreSQL opens all the indexes of a relation for every Queryduring Planning Time? (Jason Petersen)
Список
Дерево обсуждения
PostgreSQL opens all the indexes of a relation for every Query during Planning Time? Meenatchi Sandanam <meen.opm@gmail.com>
Re: PostgreSQL opens all the indexes of a relation for every Queryduring Planning Time? Jason Petersen <jason@citusdata.com>
Re: PostgreSQL opens all the indexes of a relation for every Queryduring Planning Time? Meenatchi Sandanam <meen.opm@gmail.com>
Please refer this https://www.postgresql.
On Fri, Mar 16, 2018 at 10:48 PM, Jason Petersen <jason@citusdata.com> wrote:
On Mar 15, 2018, at 4:18 AM, Meenatchi Sandanam <meen.opm@gmail.com> wrote: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?I’d think you’d need a pretty clear profiling run that points to this as a hot spot before deciding to optimize it. Do you have a query where this is the case?
В списке pgsql-hackers по дате отправления
От: Amit Langote
Дата:
От: Pavel Stehule
Дата:
