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_+xUiwb_z=097kfDWp_fkuufqWFAAMf+=EbxhN1r4kjw@mail.gmail.com
Whole thread Raw
In response to Re: BRIN is missing in multicolumn indexes documentation  (Petr Jediný <petr.jediny@gmail.com>)
Responses Re: BRIN is missing in multicolumn indexes documentation
List pgsql-hackers
Comments? This is my first patch to postgresql project, so comments
are very much welcomed.

PJ

On Wed, Mar 23, 2016 at 8:40 PM, Petr Jediný <petr.jediny@gmail.com> wrote:
>>>
>>> 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



pgsql-hackers by date:

Previous
From: Paul Ramsey
Date:
Subject: Re: Parallel Queries and PostGIS
Next
From: Amit Kapila
Date:
Subject: Re: Speed up Clog Access by increasing CLOG buffers