创建索引

TimescaleDB supports the range of PostgreSQL index types, and creating, altering, or dropping an index on the hypertable (​PostgreSQL docs​) will similarly be propagated to all its constituent chunks.

TimescaleDB支持所有的PostgreSQL索引类型，同样的，hypertable中创建、修改或者删除的索引会传递到其所有区块中。

CREATE INDEX ON conditions (location, time DESC);

For more instructions and suggestions about indexing data within TimescaleDB, as well as information about default indexes that TimescaleDB automatically creates, ​please see our indexing discussion​.

更多TimescaleDB索引数据以及Timescale自动创建的默认索引信息请查阅indexing discussion。