← Concepts

阅读中文版本

Online Repartitioning

Online Repartitioning governs partition reorganization, shaping system behavior under specific failure modes and workloads.

databases

Definition

Online Repartitioning is a design property concerning partition reorganization. It defines how the system behaves under specific conditions — what guarantees hold, what trade-offs apply, and how the mechanism interacts with related techniques. The property is only meaningful when its preconditions are met; outside those conditions it provides no benefit and may add cost.

Context and scope

Apply Online Repartitioning when designing systems where partition reorganization matters. It is most useful under partial failure, high load, or correctness requirements. Pair it with observability to verify the claimed behavior in production. Do not assume the property holds without testing the specific configuration and workload.

Common misconceptions

  • Online Repartitioning eliminates all problems in its domain — it only bounds or shapes specific failure modes, not all pathologies.
  • Online Repartitioning is free once you adopt the right tool — the property depends on configuration, workload, and failure pattern, not the product label alone.

Anti-patterns

  • Enabling Online Repartitioning without measuring its cost in latency, availability, or operational complexity under production-like conditions.
  • Assuming Online Repartitioning composes safely with other guarantees — combining mechanisms can introduce new failure modes or negate benefits.

Related concepts

Authoritative source

https://www.postgresql.org/docs/

What it is

Online Repartitioning is a design property concerning partition reorganization. It defines how the system behaves under specific conditions — what guarantees hold, what trade-offs apply, and how the mechanism interacts with related techniques. The property is only meaningful when its preconditions are met; outside those conditions it provides no benefit and may add cost.

When to use

Apply Online Repartitioning when designing systems where partition reorganization matters. It is most useful under partial failure, high load, or correctness requirements. Pair it with observability to verify the claimed behavior in production. Do not assume the property holds without testing the specific configuration and workload.

Common misconceptions

  • Online Repartitioning eliminates all problems in its domain — it only bounds or shapes specific failure modes, not all pathologies.
  • Online Repartitioning is free once you adopt the right tool — the property depends on configuration, workload, and failure pattern, not the product label alone.

Anti-patterns to avoid

  • Enabling Online Repartitioning without measuring its cost in latency, availability, or operational complexity under production-like conditions.
  • Assuming Online Repartitioning composes safely with other guarantees — combining mechanisms can introduce new failure modes or negate benefits.
  • Hash Partitioning (hash-partitioning)
  • Partition Pruning (partition-pruning)