Project

General

Profile

Actions

Question #17772

closed

"nodes" table is very big

Added by Laurent Luyckx almost 4 years ago. Updated about 1 year ago.

Status:
Resolved
Priority:
N/A
Assignee:
-
Category:
Performance and scalability
Regression:
No

Description

Hi,

Question is similar to another posted here https://issues.rudder.io/issues/15436

I'm also seeing a huge nodes table:

           Table            |    Size    | Relation size | External Size 
----------------------------+------------+---------------+---------------
 nodes                      | 44 GB      | 13 GB         | 30 GB
 groups                     | 3123 MB    | 1088 MB       | 2035 MB
 directives                 | 625 MB     | 438 MB        | 187 MB
 eventlog                   | 437 MB     | 281 MB        | 156 MB
 rules                      | 291 MB     | 205 MB        | 86 MB
 reportsexecution           | 106 MB     | 4040 kB       | 102 MB

The number of entries on the "nodes" table is very large:

rudder=# select count(*) from nodes;
   count   
-----------
 133025851
(1 row)

My question is merely the same. Can do clean old entries without breaking anything?
Is there something else I can do?

I'm nearly running out of disk space so a vacuum full will not work.

Thank you for your help


Related issues 1 (0 open1 closed)

Related to Rudder - Bug #17778: table nodes contains on entry per node per generation, which is too muchReleasedFrançois ARMANDActions
Actions

Also available in: Atom PDF