#constraint-exclusion

Choose Declarative Partitioning for PostgreSQL Time-Series: When to Range-Partition by Timestamp

Use PostgreSQL declarative RANGE partitioning on a timestamp with constraint exclusion pruning to cut I/O for time-series queries, while accepting per-partition vacuum and planner requirements.