Table partitioning splits a large table into smaller, physically separate sub-tables called partitions. PostgreSQL routes queries to only the relevant partitions, dramatically improving performance on large datasets. Partitioning Strategies Strategy Description Use Case RANGE Partition by value ranges Time-series data (by month/year) LIST Partition by explicit values Multi-tenant (by tenantid), by region HASH Partition by hash of a column Even distribution across N partitions When to Partition Tables exceeding 10 million rows or growing fast Queries primarily filter on the partition key Need to efficiently drop old data (detach partition instead of DELETE) Maintenance operations (VACUUM, REINDEX) on smaller chunks Partition Pruning PostgreSQL automatically prunes irrelevant partitions…