Emre Hasegeli wrote:
> > I guess multicolumn BRIN behaves similarly to B-tree or GiST. But I'm
> > no expert, so I need someone knowledgeable to confirm this. If the
> > following wording is OK, I will update the patch.
>
> 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.
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
