Explain GIN, GiST, BRIN, and other specialized index types.

Answer preview

B-tree only handles scalar, orderable values. PostgreSQL ships several other access methods for data where "less than" is meaningless or where the data is huge but naturally ordered: GIN, GiST, SP-GiST, BRIN, and Hash.…