[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

Generated at Thu Feb 08 23:13:57 UTC 2024 using Jira 1001.0.0-SNAPSHOT#100246-sha1:7a5c50119eb0633d306e14180817ddef5e80c75d.