• Browse categories
• PostgreSQL releases
  • PostgreSQL 15 (beta1)
  • PostgreSQL 14 (latest)
  • PostgreSQL 13
  • PostgreSQL 12
  • PostgreSQL 11
  • PostgreSQL 10
  • PostgreSQL 9.6 (EOL)

Version charts

Useful overviews

Useful links

btree_gist

btree_gist is a contrib module providing sample GiST index operator classes which implement B-tree equivalent behaviour for certain datatypes.

btree_gist was added in PostgreSQL 7.2.

Change history

Work-in-progress

• PostgreSQL 15
  • bool opclass added to allow creating GiST indexes on boolean columns (commits 57e3c516, e2fbb883 and 4c6145b5)
• PostgreSQL 14
  • marked as parallel safe (commit d98c08cd)
• PostgreSQL 13
  • marked as a trusted extension (commit eb67623c)
• PostgreSQL 10
  • support for indexing ENUM datatypes added (commit f7946a92)
  • support for indexing the UUID datatype added (commit 11da83a0)
  • support for indexing the MACADDR8 datatype added (commit c7a9fa39)
• PostgreSQL 9.1
  • support for nearest-neighbour (kNN) search added (commit 8436489c)
  • support for searching on "not equals" added (commit ad17ff95)
  • converted to an extension (commit 629b3af2)
• PostgreSQL 8.0
  • revised version with support for a wide range of data types (commit 42d06988)
• PostgreSQL 7.2
  • added (commit a9289708)

References

Categories

See also