Postgres partitions A better resources is Postgres let's us split a large table in to smaller entities, done for managebility, performance. Typical usecase includes: Improve query performance of frequently accessed data from fewer partitions. Bulk delete or upload. Eg: Delete all records more than 3 months old. Seperate stale data from actively used data. Partitioning Declarative Declarative partitioning lets us specify the desired outcome without much details on how the partition happens behind the scenes.