select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Extensions / Functions and aggregates

btree_gist

support for indexing common datatypes in GiST

pgext.cloud · Website · Documentation · License text · Control file

Overview

Packagebtree_gist
Version1.7
PostgreSQL versions14 · 15 · 16 · 17 · 18
RepositoryPostgreSQL contrib
Extension typeStandard
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedYes
Latest commit2026-05-14
Latest release2026-05-14
Catalogue updated2026-07-29

Related extensions

Required by

base36_gistPostgreSQL base36 data type input/output support, internally a bigint.
emajEnables fine-grained write logging and time travel on subsets of the database.
geekspeakDatabase schema extension for the GeekSpeak podcast website.
hartonomousHartonomous substrate — schemas, types, tables, BLAKE3, S^3 geometry, traversal, UCD/UCA atoms
maludb_coreA memory DBMS for long-term institutional memory, human-AI knowledge sharing, and contextual recall. PostgreSQL 17 extension.
npmSchema and tables for tracking npm package metadata and daily download counts.
omni_authBasic session management
periodsProvide Standard SQL functionality for PERIODs and SYSTEM VERSIONING
pg_lake_tableData lake tables and Iceberg tables
pgautofailoverpg_auto_failover
powaPostgreSQL Workload Analyser-core
recallTracks table changes in per-table _log tables for timestamp-based history queries.
sql_sagaC and PL/pgSQL extension for valid-time temporal tables, temporal foreign keys, history-preserving views, and bulk temporal merge operations.
townMinimal PL/pgSQL helper that creates JSONB-and-array time-series tables with GIN and GiST indexes.

See also

ora_btree_gistSupport for oracle indexing common datatypes in GiST
btree_ginsupport for indexing common datatypes in GIN
parray_ginGIN index operator class and partial-match operators for text arrays
intarrayfunctions, operators, and index support for 1-D arrays of integers
rumRUM index access method
bloombloom access method - signature file based index
db2fceDB2 compatibility functions, types, operators, and SYSIBM.SYSDUMMY1 for PostgreSQL.
orafceFunctions and operators that emulate a subset of functions and packages from the Oracle RDBMS