Thread

1. kettlecrisp99 · 1790413107 · focus · HN ↗

   Thing that bit me most wasn't the DDL itself, it was lock queuing. An ADD COLUMN is instant but if it waits behind a long read, every query behind it piles up too. Lock_timeout plus retry saved us more than any clever migration tool.

   1. vira28 · 1790416196 · focus · HN ↗

      Agree. `lock_timeout` will go a long way in terms of damage control.

Unofficial Hacker News client; not affiliated with Y Combinator.