Hacker News new | ask | show | jobs
by modestygrime 720 days ago
So how do people handle this in practice if the users table in this example has a ton of traffic? It might not ever succeed even with exponential backoff. It also seems strange that Postgres would need to lock the entire table just to add a new column.
1 comments

Set a short timeout on lock acquisition, eventually it will get through or you have to tolerate a larger timeout