GiST stands for Generalized Search Tree. GiST is a balanced, tree-structured access method. GiST can function as a base template that can be used to implement indexing schemes. B-trees, R-trees, and other indexing schemes can be implemented in GiST.

Scenarios

  • Geometric type: supports location searches based on relative position operators such as inclusion, intersect, and located above, below, on the left, and on the right. The locations are sorted by distance.Scenario 1
  • Range type: supports location searches based on relative position operators such as inclusion, intersect, and located on the left and on the right.
  • IP type: supports location searches based on relative position operators such as inclusion, intersect, and located on the left and on the right.
  • Spatial type (PostGIS): supports location searches based on relative position operators such as inclusion, intersect, and located above, below, on the left, and on the right. The locations are sorted by distance.Scenario 2
  • Scalar type: allows locations to be sorted by distance.

Operators

  • <<
  • &<
  • &>
  • >>
  • <<|
  • &<|
  • <@
  • ~=
  • &&
  • |>>
  • @>
  • |&>