Limitations

    • Foreign key constraints referencing a hypertable are not supported.
    • Time dimensions (columns) used for partitioning cannot have NULL values.
    • Unique indexes must include all columns that are partitioning dimensions.

    Distributed Hypertable Limitations

    • Distributed scheduling of background jobs is not supported. Background jobs created on an access node are scheduled and executed on this access node without distributing the jobs to data nodes.
    • Continuous aggregates are not supported.
    • Compression policies are not supported. However, you can enable compression on the distributed hypertable and manually execute .
    • Reordering chunks is not supported.
    • Tablespaces cannot be attached to a distributed hypertable on the access node. It is still possible attach tablespaces on data nodes.
    • Joins on data nodes are not supported. Joining a distributed hypertable with another table requires the other table to reside on the access node. This also limits the performance of joins on distributed hypertables.
    • Tables referenced by foreign key constraints in a distributed hypertable must be present on the access node and all data nodes. This applies also to referenced values.
    • Parallel-aware scans and appends are not supported.
    • A consistent restore point for backup/restore across nodes is not natively provided; care must be taken when restoring individual backups to access and data nodes.
    • Native replication limitations are described .