Opened 10 years ago
Closed 10 years ago
#801 closed defect (fixed)
Postgres cannot index huge text strings
| Reported by: | Piero Campalani | Owned by: | Piero Campalani |
|---|---|---|---|
| Priority: | major | Milestone: | 9.0.x |
| Component: | petascope | Version: | development |
| Keywords: | index ps_extra_metadata value | Cc: | James Passmore |
| 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 by , 10 years ago
| Status: | new → accepted |
|---|
comment:2 by , 10 years ago
| Resolution: | → fixed |
|---|---|
| Status: | accepted → closed |
Note:
See TracTickets
for help on using tickets.
Index removed in changeset:4176c4b: unique contraint now on id and metadata type only.