[FOLIO-2254] Remove outdated indexes on jsonb->>'foreignKeyId' field Created: 11/Sep/19 Updated: 03/Jun/20 Resolved: 04/Dec/19 |
|
| Status: | Closed |
| Project: | FOLIO |
| Components: | None |
| Affects versions: | None |
| Fix versions: | None |
| Type: | Task | Priority: | P2 |
| Reporter: | Hongwei Ji | Assignee: | Hongwei Ji |
| Resolution: | Done | Votes: | 0 |
| Labels: | platform-backlog | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original estimate: | Not Specified | ||
| Issue links: |
|
||||||||||||||||||||||||||||
| Sprint: | CP: sprint 78 | ||||||||||||||||||||||||||||
| Story Points: | 0 | ||||||||||||||||||||||||||||
| Development Team: | Core: Platform | ||||||||||||||||||||||||||||
| Description |
|
Once
"tableName": "holdings_record",
"ginIndex": [
{
"fieldName": "instanceId",
"tOps": "ADD",
"caseSensitive": false,
"removeAccents": true
},
{
"fieldName": "permanentLocationId",
"tOps": "ADD",
"caseSensitive": false,
"removeAccents": true
},
{
"fieldName": "temporaryLocationId",
"tOps": "ADD",
"caseSensitive": false,
"removeAccents": true
}
]
We have tickets for individual modules, so this becomes an umbrella ticket. We should skip scoring this one and close it once all module tickets are completed. |
| Comments |
| Comment by Jakub Skoczen [ 19/Sep/19 ] |
|
Hongwei Ji can you please create tickets for individual modules (modinvstor, modcircstor, etc)? |
| Comment by Hongwei Ji [ 19/Sep/19 ] |
|
Jakub Skoczen I did a quick GitHub search and created four user store BTW, mod-users has one place but it does not specify foreign keys in schema.json |
| Comment by Julian Ladisch [ 20/Sep/19 ] |
|
This should be part of bumping the RMB version that contains
|
| Comment by Julian Ladisch [ 20/Sep/19 ] |
|
We should extend this issue to also remove indexes on the primary key "id". Postgresql automatically creates an index for the primary key therefore this additional index is not needed. |
| Comment by Julian Ladisch [ 02/Dec/19 ] |
|
https://github.com/folio-org/raml-module-builder/blob/master/doc/upgrading.md#version-271 contains this upgrading instructions for 27.1: |
| Comment by Hongwei Ji [ 04/Dec/19 ] |
|
Completed all four children tickets. Close this one as well now. |