intermediatetermWeb foundationsWeb foundations / Backend and APIs / Partitioning
IntermediateNot yet reviewed

Partitioning

Dividing a large database table into smaller, independent logical parts within a single database instance.

Definition

Dividing a large database table into smaller, independent logical parts within a single database instance.

Use case

Partitioning log tables by month (logs_2026_01, logs_2026_02) to make dropping old historical data instant.

Related terms

Documentation

Table partitioning

PostgreSQL · Docs · link checked 2026-10-16

Dividing big tables into manageable pieces inside one database.

Suggest a change