Re: BRIN is missing in multicolumn indexes documentation - Mailing list pgsql-hackers

From Petr Jediný
Subject Re: BRIN is missing in multicolumn indexes documentation
Date
Msg-id CAD=W4J_Ui1G7eh=bNqsMgPDMc9GQELLp5sJ2asOLkUpJW-_DHA@mail.gmail.com
Whole thread Raw
In response to Re: BRIN is missing in multicolumn indexes documentation  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: BRIN is missing in multicolumn indexes documentation
List pgsql-hackers
>>
>> Multicolumn BRIN is like GIN.  Every column is indexed separately.
>> The order of the columns doesn't matter.
>
> Right.  You can use one index to cover all columns; the position of the
> column in the index won't matter for a query that uses one column.  The
> only reason to have multiple BRIN indexes on a single table is to have
> a different pages_per_range.

Thanks for the information, I've attached the patch updated to v2.


PJ

Attachment

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Rationalizing code-sharing among src/bin/ directories
Next
From: Robert Haas
Date:
Subject: Re: Relation extension scalability