From Dev.to
A 3 ms ALTER can stall Postgres: how to migrate a 5-billion-row table with no downtime
An ALTER TABLE that takes 3 ms can still stall every query on the table. In my first demo it took 3 ms. In a second one, on real Postgres, a long transaction held the table, so a similar ALTER waited...