medium10 pts · first answer countslockingpostgresql
A migration froze the whole app
An ALTER TABLE ... ADD COLUMN waited behind a long SELECT, and during that time every other query on the table hung. What is the safest way to run such migrations?
An ALTER TABLE ... ADD COLUMN waited behind a long SELECT, and during that time every other query on the table hung. What is the safest way to run such migrations?