GiST, SP-GiST, hash index

Also written: GiST, SP-GiST, hash index

Less common index types. GiST handles overlapping or nearby values such as ranges and geometry, SP-GiST suits data that splits into non-overlapping parts, and a hash index supports only `=`.