Why Partition: Pruning, Maintenance
Understand the wins of partitioning: query pruning, faster VACUUM, easier archival.
What Is Partitioning?
Splitting one logical table into many physical tables (partitions), each holding a subset of rows. Queries scan only relevant partitions.
Why Bother?
Big tables hurt:
- Indexes grow huge, lookups get slower
- VACUUM takes hours
- Backups are slow
- Some queries scan unnecessarily
Partitioning addresses all four.
All lessons in this course
- Why Partition: Pruning, Maintenance
- Range, List and Hash Partitioning
- Detaching and Attaching Partitions
- Querying Across Partitions Efficiently