Project

General

Profile

Actions

Bug #8058

closed

Bug #8057: Queries on expected reports are really slow with more than 2000 nodes

Add indexes on expected reports table

Added by Nicolas CHARLES about 8 years ago. Updated about 8 years ago.

Status:
Released
Priority:
N/A
Category:
Performance and scalability
Target version:
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);

Actions #1

Updated by Nicolas CHARLES about 8 years ago

  • Description updated (diff)
  • Assignee set to François ARMAND
Actions #2

Updated by Vincent MEMBRÉ about 8 years ago

  • Target version changed from 3.0.15 to 3.0.14
Actions #3

Updated by François ARMAND about 8 years ago

  • Status changed from New to In progress
Actions #4

Updated by François ARMAND about 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
Actions #5

Updated by François ARMAND about 8 years ago

  • Status changed from Pending technical review to Pending release
  • % Done changed from 0 to 100
Actions #6

Updated by Vincent MEMBRÉ about 8 years ago

  • Status changed from Pending release to Released

This bug has been fixed in Rudder 2.11.19, 3.0.14, 3.1.8 and 3.2.1 which were released today.

Actions

Also available in: Atom PDF