Project

General

Profile

Actions

Bug #18110

closed

Unused index on table Ruddersysevents

Added by Nicolas CHARLES over 4 years ago. Updated almost 4 years ago.

Status:
Released
Priority:
N/A
Category:
Performance and scalability
Target version:
Severity:
UX impact:
User visibility:
Effort required:
Priority:
0
Name check:
To do
Fix check:
Checked
Regression:

Description

We have an index on keyvalue, dating from when we searched on keyvalue for compliance (pre 5.0)
0 query use it, we can safely remove it
It saves about 10%-20% of table ruddersysevent


Related issues 1 (0 open1 closed)

Related to Rudder - Bug #18111: create migration script to remove index on keyvalueReleasedAlexis MoussetActions
Actions #1

Updated by Nicolas CHARLES over 4 years ago

  • Status changed from New to In progress
  • Assignee set to Nicolas CHARLES
Actions #2

Updated by Nicolas CHARLES over 4 years ago

  • Status changed from In progress to Pending technical review
  • Assignee changed from Nicolas CHARLES to François ARMAND
  • Pull Request set to https://github.com/Normation/rudder/pull/3172
Actions #3

Updated by Nicolas CHARLES about 4 years ago

  • Pull Request changed from https://github.com/Normation/rudder/pull/3172 to https://github.com/Normation/rudder/pull/3199
Actions #4

Updated by Nicolas CHARLES about 4 years ago

  • Status changed from Pending technical review to Pending release
Actions #5

Updated by Vincent MEMBRÉ about 4 years ago

This bug has been fixed in Rudder 6.2.0~beta1 which was released today.

Actions #6

Updated by François ARMAND about 4 years ago

  • Fix check changed from To do to Checked
Actions #7

Updated by Vincent MEMBRÉ almost 4 years ago

  • Related to Bug #18111: create migration script to remove index on keyvalue added
Actions #8

Updated by Vincent MEMBRÉ almost 4 years ago

  • Status changed from Pending release to Released
Actions

Also available in: Atom PDF