Timescale Cloud: Performance, Scale, Enterprise
Self-hosted products
MST
While Timescale generally offers capabilities that go beyond what PostgreSQL offers, there are some limitations to using hypertables, and, in particular, distributed hypertables. This section documents the common limitations when using both regular and distributed hypertables.
- Time dimensions (columns) used for partitioning cannot have NULL values.
- Unique indexes must include all columns that are partitioning dimensions.
UPDATE
statements that move values between partitions (chunks) are not supported. This includes upserts (INSERT ... ON CONFLICT UPDATE
).- Foreign key constraints from a hypertable referencing another hypertable are not supported.
Keywords
Found an issue on this page?Report an issue or Edit this page
in GitHub.