Custom index instead of created by default

TimescaleDB and PostgreSQL
1

Hi! Can I safely delete default index on timestamp column and create instead of it other index with the same desc timestamp column and additional columns?
In technical words:

DELETE INDEX schema.time_column_idx;
CREATE INDEX time_column_additional_col_idx ON schema.some_table USING btree(time_column DESC, additional_col);

Whould it be right for work of Timescale with hypertable after this changing?

1 Like
2

The question is closed.
I found the answer in the documentation and ChatGPT also gave me the right answer.