Nice feature to have, but people have been using postgres (and other databases) sucessfully for years. How did they work around it?

You either move the blocking operation elsewhere (i.e., a trigger) or you don't. Data consistency is more important than performance (normally). The user can wait.

I roll a natural twenty.