Postgres cannot index huge text strings
|Reported by:||pcampalani||Owned by:||pcampalani|
|Keywords:||index ps_extra_metadata value||Cc:||jpass|
The value field of the table petascopedb::ps_extra_metadata is involved in a UNIQUE constraint (is indexed) and can contain huge strings which inhibits insertion on relatively big input (see link).
The UNIQUE constraint should be relaxed to involve only the coverage_id and metadata_type_id, which anyway is sufficient (it makes more sense indeed).