I am relatively new to timescaledb.
When a hypertable is created, the timescaledb automatically creates default index. Although there is a option to disable creating default index, can we drop the already created index without any issues in operations of timescaledb?
I would like to replace the existing default btree index on timestamp with a BRIN index to reduce the storage requirements.