`SELECT FOR UPDATE` solves that problem completely or almost completely.

I believe that too few people have such a huge load. In 99% if the database can handle 10K warehouses, it's more than enough.