CREATE INDEX ... WITH (timescaledb.transaction_per_chunk, ...);
This option extends [
CREATE INDEX][postgres-createindex] with the
ability to use a separate transaction for each chunk it creates an
index on, instead of using a single transaction for the entire hypertable.
INSERTs, and other operations to be performed concurrently
during most of the duration of the
CREATE INDEX command.
While the index is being created on an individual chunk, it functions as
if a regular
CREATE INDEX were called on that chunk, however other chunks are
CREATE INDEXcan be used as an alternative to
CREATE INDEX CONCURRENTLY, which is not currently supported on hypertables.
\d+on the hypertable). The index will still work, and will be created on new chunks, but if you wish to ensure _all_ chunks have a copy of the index, drop and recreate it.
CREATE INDEX ON conditions(time, device_id) WITH (timescaledb.transaction_per_chunk);
Other index methods
CREATE INDEX ON conditions(time, location) USING brin WITH (timescaledb.transaction_per_chunk);