Re:BRIN Index for PostgreSQL: Don’t Forget the Benefits
by paulddraper on Friday July 19, 2019 @01:00PM
(#20480415)
tl;dr is this:
> BRIN indexes are efficient if the ordering of the key values follows the organization of blocks in the storage layer....Keys on generated sequence numbers or created data are best candidates for BRIN index
> BRIN indexes are efficient if the ordering of the key values follows the organization of blocks in the storage layer....Keys on generated sequence numbers or created data are best candidates for BRIN index