PostgreSQL DBA

Partitioning, Storage & Maintenance Operations

Question

Range versus list partitioning: how do their bounds differ, and when should each be used?

Answer

Range partitions define non-overlapping intervals, with inclusive lower and exclusive upper bounds. List partitions define explicit discrete values. Use range for time or ordered keys; use list for known categories, tenants, or regions.

This is 12 of 23 free samples for PostgreSQL DBA.

More PostgreSQL DBA topic samples