Tiger Cloud: Performance, Scale, Enterprise

Self-hosted products

MST

While TimescaleDB generally offers capabilities that go beyond what PostgreSQL offers, there are some limitations to using hypertables.

Hypertable limitations

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.

Limitations