[FOLIO-1522] Perf tests should not create indexes Created: 20/Sep/18 Updated: 01/Apr/19 |
|
| Status: | Open |
| Project: | FOLIO |
| Components: | None |
| Affects versions: | None |
| Fix versions: | None |
| Type: | Bug | Priority: | P3 |
| Reporter: | Heikki Levanto | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original estimate: | Not Specified | ||
| Sprint: | |
| Development Team: | Core: Platform |
| Description |
|
The perf tests drop all indexes, load the test data, and manually (re)create the indexes. This is prone to fall out of sync with the indexes the modules actually create. It would be better to disable the indexes for the bulk load and re-enable them and reindex when done. |
| Comments |
| Comment by Heikki Levanto [ 20/Sep/18 ] |
|
I found a nice little article that shows one way how it can be done: https://fle.github.io/temporarily-disable-all-indexes-of-a-postgresql-table.html |