PostgreSQL 10 data types and indexes
The six commonly used index types in PostgreSQL 10 are btree,hash,gin,gist,spgist and hash. Btree and hash are the longest, and almost all data types are supported. The following data types supported for gin,gist,spgist,brin indexes are summarized as follows:
