Project

General

Profile

Actions
Copy link

Bug #29154

open

nodelastcompliance table can get *really* big

Bug #29154: nodelastcompliance table can get *really* big

Added by Nicolas CHARLES 2 months ago. Updated 10 days ago.

Status:
Pending release
Priority:
1 (highest)
Assignee:
Nicolas CHARLES
Category:
Performance and scalability
Target version:
9.0.10
Pull Request:
https://github.com/Normation/rudder/p...
Severity:
UX impact:
User visibility:
Effort required:
Priority:
0
Name check:
To do
Fix check:
To do
Regression:
No

Description

We don't do any maintenance on it, so the table grows out of bound.
A user had 42GB for this table, and a vacuum full brought it back to a reasonable 156MB in 4 seconds

we should do a vacuum full every night, along with all other database maintenance

Subtasks 1 (1 open — 0 closed)

Bug #29663: Autovacuuming of nodelastcompliance could be improvedPending technical reviewFrançois ARMANDActions

Updated by Nicolas CHARLES 2 months ago Actions
Copy link
 #1

  • Assignee set to Clark ANDRIANASOLO
  • Priority changed from To review to 1 (highest)
we could:
  • define an autovacuum on the table (like the other tables)
  • force a vacuum every night as in ReportsJdbcRepository.scala
  • reclaim once the disk space by doing a one-shot vacuum full

Updated by Vincent MEMBRÉ 2 months ago Actions
Copy link
 #2

  • Target version changed from 9.0.8 to 9.0.9

Updated by Clark ANDRIANASOLO about 1 month ago Actions
Copy link
 #3

  • Status changed from New to In progress

Updated by Clark ANDRIANASOLO about 1 month ago Actions
Copy link
 #4

  • Status changed from In progress to Pending technical review
  • Assignee changed from Clark ANDRIANASOLO to Nicolas CHARLES
  • Pull Request set to https://github.com/Normation/rudder/pull/7369

Updated by Alexis Mousset about 1 month ago Actions
Copy link
 #5

  • Target version changed from 9.0.9 to 9.0.10

Updated by Nicolas CHARLES 25 days ago Actions
Copy link
 #6

  • Assignee changed from Nicolas CHARLES to François ARMAND

Updated by Clark ANDRIANASOLO 25 days ago Actions
Copy link
 #7

  • Assignee changed from François ARMAND to Nicolas CHARLES

Updated by Clark ANDRIANASOLO 18 days ago Actions
Copy link
 #8

  • Assignee changed from Nicolas CHARLES to François ARMAND

Updated by Clark ANDRIANASOLO 13 days ago Actions
Copy link
 #9

  • Assignee changed from François ARMAND to Nicolas CHARLES

Updated by Clark ANDRIANASOLO 11 days ago Actions
Copy link
 #10

  • Subtask #29663 added

Updated by Clark ANDRIANASOLO 10 days ago Actions
Copy link
 #11

  • Status changed from Pending technical review to Pending release
Actions
Copy link

Also available in: PDF Atom