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.