Adds unique indices to help with deleting orphaned kv_store. This is needed since deleting something from kv_store will require
postgres checking base_result to make sure the entry is not being referenced. This takes multiple seconds per KVStore record, which is not acceptable when trying to clean up several million.
In addition, this makes molecule hashes unique
Changelog description
Add unique indices to base_result for kv_store foreign keys, and makes molecule hash unique.
codecov[bot]
commented
3 years ago
Description
Adds unique indices to help with deleting orphaned kv_store. This is needed since deleting something from kv_store will require postgres checking base_result to make sure the entry is not being referenced. This takes multiple seconds per KVStore record, which is not acceptable when trying to clean up several million.
In addition, this makes molecule hashes unique
Changelog description
Add unique indices to base_result for kv_store foreign keys, and makes molecule hash unique.
Status