4 ms·
Hi @neslinesli93, it's quite easy: (1) Call create_hypertable with default indexes off (include an argument of `create_default_indexes => FALSE`) [1] (2) Then
by mfreed 8y ago
Hi @neslinesli93, it's quite easy:
(1) Call create_hypertable with default indexes off (include an argument of `create_default_indexes => FALSE`) [1]
(2) Then just use a standard CREATE INDEX command on the hypertable at any time. B-Tree, hash index, GIN/Gist, single key, composite keys, etc. This DDL command will propagate to any existing chunks (and create them) and will be remembered to so any future chunks that are automatically created will also have these indexes [2]
[1] https://docs.timescale.com/latest/api#create_hypertable https://docs.timescale.com/latest/api#create_hypertable
[2] https://docs.timescale.com/latest/using-timescaledb/schema-management#indexing https://docs.timescale.com/latest/using-timescaledb/schema-m...