Extensions / Functions and aggregates
support for indexing common datatypes in GiST
pgext.cloud · Website · Documentation · License text · Control file
| Package | btree_gist |
|---|---|
| Version | 1.7 |
| PostgreSQL versions | 14 · 15 · 16 · 17 · 18 |
| Repository | PostgreSQL contrib |
| Extension type | Standard |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | Yes |
| Latest commit | 2026-05-14 |
| Latest release | 2026-05-14 |
| Catalogue updated | 2026-07-29 |
| base36_gist | PostgreSQL base36 data type input/output support, internally a bigint. |
| emaj | Enables fine-grained write logging and time travel on subsets of the database. |
| geekspeak | Database schema extension for the GeekSpeak podcast website. |
| hartonomous | Hartonomous substrate — schemas, types, tables, BLAKE3, S^3 geometry, traversal, UCD/UCA atoms |
| maludb_core | A memory DBMS for long-term institutional memory, human-AI knowledge sharing, and contextual recall. PostgreSQL 17 extension. |
| npm | Schema and tables for tracking npm package metadata and daily download counts. |
| omni_auth | Basic session management |
| periods | Provide Standard SQL functionality for PERIODs and SYSTEM VERSIONING |
| pg_lake_table | Data lake tables and Iceberg tables |
| pgautofailover | pg_auto_failover |
| powa | PostgreSQL Workload Analyser-core |
| recall | Tracks table changes in per-table _log tables for timestamp-based history queries. |
| sql_saga | C and PL/pgSQL extension for valid-time temporal tables, temporal foreign keys, history-preserving views, and bulk temporal merge operations. |
| town | Minimal PL/pgSQL helper that creates JSONB-and-array time-series tables with GIN and GiST indexes. |
| ora_btree_gist | Support for oracle indexing common datatypes in GiST |
| btree_gin | support for indexing common datatypes in GIN |
| parray_gin | GIN index operator class and partial-match operators for text arrays |
| intarray | functions, operators, and index support for 1-D arrays of integers |
| rum | RUM index access method |
| bloom | bloom access method - signature file based index |
| db2fce | DB2 compatibility functions, types, operators, and SYSIBM.SYSDUMMY1 for PostgreSQL. |
| orafce | Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS |