select open change scope Open full search

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

Extensions / Time series

temporal_rtree

Experimental temporal R-tree access method implemented as a PostgreSQL extension.

pgext.cloud · Source code · Documentation · Control file

Overview

Packagetemporal_rtree
Version1.0
RepositoryUnspecified
Extension typeStandard
Project statusActive
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableYes
Stars0
Latest commit2026-04-30
Catalogue updated2026-08-30

Related extensions

See also

temporal_tablestemporal tables
emajEnables fine-grained write logging and time travel on subsets of the database.
temporalC extension providing a PERIOD type over timestamp-with-time-zone values, temporal relation operators and functions, plus GiST indexing support.
pg_temporalPostgreSQL extension adding Temporal ZonedDateTime support.
sql_sagaC and PL/pgSQL extension for valid-time temporal tables, temporal foreign keys, history-preserving views, and bulk temporal merge operations.
time_for_keysC and PL/pgSQL helpers that enforce temporal foreign keys between valid-time tables with constraint triggers.
timeqlNative temporal history tracking and point-in-time queries using PostgreSQL range types and GiST indexes.
pgtimeTemporal tables extension for PostgreSQL. Automatically tracks Transaction Time (system time) on any table using range types and a high-performance C-based AFTER ROW trigger.