select open change scope Open full search

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

Extensions / Time series

town

Minimal PL/pgSQL helper that creates JSONB-and-array time-series tables with GIN and GiST indexes.

pgext.cloud · Source code · Documentation · License text · Control file

Overview

Packagetown
Version0.1.0
RepositoryUnspecified
Extension typeSQL only
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableYes
Stars31
Latest commit2021-11-09
Catalogue updated2026-08-30

Related extensions

Requires

btree_gistsupport for indexing common datatypes in GiST
plpgsqlPL/pgSQL procedural language

See also

timescaledbEnables scalable inserts and complex queries for time-series data
pgbsonBSON data type and accessor functions for PostgreSQL
timeseriesConvenience API for time series stack
jsonb_delete_arrayDelete jsonb keys or string elements listed in a text array
pg_deltaxFast time-series extension for PostgreSQL
pg_statvizCapture PostgreSQL statistics snapshots for time-series analysis and visualization
pgsamplerExperimental PostgreSQL background worker that collects time-series status and performance metrics.
pipelinedbRun continuous SQL queries for high-throughput incremental time-series aggregation in PostgreSQL
pg_stlTime series analysis functions for PostgreSQL
timescaledb_toolkitLibrary of analytical hyperfunctions, time-series pipelining, and other SQL utilities