Postgres Table Partitioning: Splitting Huge Tables by Time
Partition a live time-series Postgres table: choose the range key, migrate without long locks, verify pruning, and automate retention with pg_partman.
20 min read
Tag
Partition a live time-series Postgres table: choose the range key, migrate without long locks, verify pruning, and automate retention with pg_partman.
20 min read
Learn how range partitioning by time works in PostgreSQL, when partition pruning helps, how pg_partman automates retention, and when to avoid it.
15 min read