Opened 3 years ago

Closed 3 years ago

#801 closed defect (fixed)

Postgres cannot index huge text strings

Reported by: pcampalani Owned by: pcampalani
Priority: major Milestone: 9.0.x
Component: petascope Version: development
Keywords: index ps_extra_metadata value Cc: jpass
Complexity: Easy

Description

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).

Change History (2)

comment:1 Changed 3 years ago by pcampalani

  • Status changed from new to accepted

comment:2 Changed 3 years ago by pcampalani

  • Resolution set to fixed
  • Status changed from accepted to closed

Index removed in changeset:4176c4b: unique contraint now on id and metadata type only.

Note: See TracTickets for help on using tickets.