kb/indexes

PostgreSQL indexes: B-tree, GIN, GiST, BRIN, hash

Operator classes as the bridge from a data type to an access method, the internals of B-tree, hash, GiST/SP-GiST, GIN, and BRIN, designing composite, covering, and partial indexes, and sargability.