Re: BRIN is missing in multicolumn indexes documentation

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

Предыдущее
От: Paul Ramsey
Дата:
Сообщение: Re: Parallel Queries and PostGIS
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: Speed up Clog Access by increasing CLOG buffers