Add a partition for a date range.
Section: High-value Query Performance Patterns
Attach partition
sql
sql
CREATE TABLE metrics_2026_03 PARTITION OF metrics
FOR VALUES FROM ('2026-03-01') TO ('2026-04-01');Explanation
See summary for usage details.
Learn the surrounding workflow
Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.
Related commands
Same sheet · prioritizing High-value Query Performance Patterns
Create range-partitioned table
Partition large time-series tables by range.
Keyset pagination
Prefer keyset pagination over deep OFFSET scans for large result sets.
Select needed columns
Avoid fetching unnecessary columns, especially wide rows.
Covering index with INCLUDE
Use included columns to support index-only reads for certain queries.
Batch updates
Chunk large writes into batches to reduce contention and WAL spikes.