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.