create_index_for_contract locks the table for writes

The create_index_for_contract procedure does not build the index concurrently (see postgres docs), and as such locks the table for writes during the whole index creation.