Actions
Bug #8058
closed
Bug #8057: Queries on expected reports are really slow with more than 2000 nodes
Add indexes on expected reports table
Status:
Released
Priority:
N/A
Assignee:
Category:
Performance and scalability
Target version:
Pull Request:
Severity:
UX impact:
User visibility:
Effort required:
Priority:
Name check:
Fix check:
Regression:
Description
We are lacking indexes on expected reports table
These two indexes need to be added
CREATE INDEX nodeconfigids_idx on expectedreportsnodes USING GIN (nodeconfigids);
Updated by Nicolas CHARLES over 8 years ago
- Description updated (diff)
- Assignee set to François ARMAND
Updated by Vincent MEMBRÉ over 8 years ago
- Target version changed from 3.0.15 to 3.0.14
Updated by François ARMAND over 8 years ago
- Status changed from New to In progress
Updated by François ARMAND over 8 years ago
- Status changed from In progress to Pending technical review
- Assignee changed from François ARMAND to Nicolas CHARLES
- Pull Request set to https://github.com/Normation/rudder/pull/1061
Updated by François ARMAND over 8 years ago
- Status changed from Pending technical review to Pending release
- % Done changed from 0 to 100
Applied in changeset rudder|fc5a6cc82c74dc6c18643503c3ce1611656d62b5.
Updated by Vincent MEMBRÉ over 8 years ago
- Status changed from Pending release to Released
Actions