Tablespaces and Storage Management — Tiering Data Across Storage Classes

Not all data deserves the same storage hardware. Current-month orders need fast NVMe SSD. Two-year-old archive data can live on cheap spinning disk or object storage. PostgreSQL tablespaces let you route different tables, indexes, and partitions to different physical directories — and therefore different storage classes — without changing your SQL.