Re: BRIN is missing in multicolumn indexes documentation

Поиск
Список
Период
Сортировка
От Petr Jediný
Тема Re: BRIN is missing in multicolumn indexes documentation
Дата
Msg-id CAD=W4J_Ui1G7eh=bNqsMgPDMc9GQELLp5sJ2asOLkUpJW-_DHA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: BRIN is missing in multicolumn indexes documentation  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Ответы Re: BRIN is missing in multicolumn indexes documentation  (Petr Jediný <petr.jediny@gmail.com>)
Список 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

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Rationalizing code-sharing among src/bin/ directories
Следующее
От: Robert Haas
Дата:
Сообщение: Re: Relation extension scalability