select open change scope Open full search

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

Extensions / Features

pg_ttl_index

Automatic data expiration with TTL indexes

pgext.cloud · Source code · Website · License text · Control file · PGXN

Overview

Packagepg_ttl_index
Version3.0.0
PostgreSQL versions15 · 16 · 17 · 18
RepositoryPIGSTY
Extension typePreloaded
Requires CREATE EXTENSIONYes
Requires preloadYes
TrustedNo
RelocatableYes
Shared librariespg_ttl_index
Stars24
Latest commit2026-03-21
Latest release2026-03-20
Catalogue updated2026-08-30

Related extensions

See also

timescaledbEnables scalable inserts and complex queries for time-series data
pg_partmanExtension to manage partitioned tables by time or ID
citusDistributed PostgreSQL as an extension
pg_fkpartTable partitioning by foreign key utility
timeseriesConvenience API for time series stack
pg_cronJob scheduler for PostgreSQL