Get the latest tech news

Designing DB partitions you don't have to babysit


Six months in, p_future holds 800M rows because the growth projection didn't survive the workload, and every ALTER to fix it needs a maintenance window nobody wants to schedule. The boundary management is two lines of DDL; the harder part is picking a partition key that doesn't leak into application code.

None

Get the Android app

Or read this on Hacker News

Read more on:

Photo of Partitions

Partitions

Photo of Designing DB

Designing DB

Related news:

News photo

Partitions over Permutations