Postgresql 中文操作指南

68.5. Examples #

PostgreSQL 源发行版包括使用 GiST 实现的几个索引方法示例。核心系统目前提供文本搜索支持（tsvector 和 tsquery 的索引）以及某些内置几何数据类型的 R 树等效功能（参见 src/backend/access/gist/gistproc.c）。以下 contrib 模块还包含 GiST 运算符类：

The PostgreSQL source distribution includes several examples of index methods implemented using GiST. The core system currently provides text search support (indexing for tsvector and tsquery) as well as R-Tree equivalent functionality for some of the built-in geometric data types (see src/backend/access/gist/gistproc.c). The following contrib modules also contain GiST operator classes:

  • btree_gist

    • B-tree equivalent functionality for several data types

  • cube

    • Indexing for multidimensional cubes

  • hstore

    • Module for storing (key, value) pairs

  • intarray

    • RD-Tree for one-dimensional array of int4 values

  • ltree

    • Indexing for tree-like structures

  • pg_trgm

    • Text similarity using trigram matching

  • seg

    • Indexing for “float ranges”