Postgres Indexes for Newbies
I’m loving all the Postgres submissions on HN over the last couple days.  My professional experience is mostly with Redshift which is only Postgres-like.I was not aware of BRIN indexes.  Am I correct in assuming those are suitable for analytical workloads?  Is the data implicitly sorted in a BRIN index or is there a mechanism to optimize the storage layer for BRIN indexed data?