> ## Documentation Index
> Fetch the complete documentation index at: https://internal.softcrum.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Runbook — Partition Management

> 1. Monthly (automated, verify): cron creates partitions N+2 for all designated tables; check job green + partitions exist (\d+ core.tracked_events). 2.

1. **Monthly (automated, verify):** cron creates partitions N+2 for all designated tables; check job green + partitions exist (`\d+ core.tracked_events`).
2. **DEFAULT partition alert fires:** rows landed outside ranges ⇒ a partition wasn't created or bad occurred\_at. Create missing partition, move rows, find producer bug, add test.
3. **Retention cycle (per tenant plan):** export partition → Storage `exports/{tenant}/{table}/{yyyymm}.ndjson.gz` → checksum → verify readable → DROP partition → record in audit\_log (system actor).
4. **pg\_partman spike result:** \[pending] if available on Supabase, migrate creation/retention to partman config and simplify steps 1–3.
5. **Restore request:** locate export in Storage → load into `restore_{table}` staging → hand to tenant-restore runbook.