Actions
Question #17772
closed"nodes" table is very big
Status:
Resolved
Priority:
N/A
Assignee:
-
Category:
Performance and scalability
Target version:
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
Actions