Origin story
After one too many production incidents caused by naive ALTER TABLE statements, I collected the patterns that kept large tables online and wrapped them in a small, tested package.
pg-toolkit
Open-source helpers born from client work: concurrent index creation wrappers, bloat estimation queries and safe column-type change recipes that never take an ACCESS EXCLUSIVE lock on hot tables.
Highlights
- CONCURRENTLY-aware schema helpers
- Bloat and index-audit reporting commands
- Documented recipes for safe column changes