search

timescale / timescaledb

An open-source time-series SQL database optimized for fast ingest and complex queries. Packaged as a PostgreSQL extension.
https://www.timescale.com/
Other
17.49k stars 876 forks source link

[Enhancement]: Remove block for unique index creation and constraint creation on compressed hypertables #5595

Open antekresic opened 1 year ago

antekresic commented 1 year ago

What type of enhancement is this?

User experience

What subsystems and features will be improved?

Compression

What does the enhancement do?

Right now, we block creation of unique index and constraint creation on compressed hypertables. We should remove the block and ensure the correctness of these relations during creation by decompressing the necessary data and verifying they can be enforced on already existing data.

Implementation challenges

There are possible optimizations to be done in case the constraints are created on segmentby/orderby columns only.

WausD commented 1 year ago

Hey antekresic, we have the problem with the block for unique index creatin.... In which version is the block disabled? We are using the Version 2.11.2 of timescaledb

iliyas-patel-git commented 3 months ago

Any plans to fix this soon? It would be great if someone could prioritize this fix.