Melvin Davidson schrieb am 23.01.2016 um 16:27:
> http://www.postgresql.org/docs/9.5/interactive/brin-intro.html
>
> 62.1. Introduction
> ...
> "A block range is a group of pages that are physically adjacent in the table; for each block range, some summary info
isstored by the index."
>
> From the above, may I presume that it is best to cluster (or sort),
> the table based on the intended BRIN column(s) before actually
> creating the index to insure the pages are adjacent? If so, should
> that not be included in the documentation, instead of implied?
>
That is something I am also curious about. If that was true, it would mean that BRIN indexes couldn't be used on tables
thatare not clustered along the index and it wouldn't make sense to have more than one BRIN index.
Thomas
