We have been using n8n for 8-9 months in a docker container. I reserved 2 cpu and 4 gb ram just for n8n.
For several weeks, we have been encountering problems where the n8n container “goes crazy”: the 2 CPUs at 100% and 98% of the RAM used.
The only way is to restart the container. When the container restarts it happens that it starts again to take 100% of the resources allocated to it.
Obviously, all systems using n8n webhooks are on hold and blocking.
For 8-9 months, the POSTGRESQL n8n database has weighed 1.3 GB, with more than 356,000 rows.
Have you seen this problem before?
I was wondering if this was not related to the large number of rows in the “execution_entity” table.
How can we purge this table?
Can we automatically delete all lines older than 3 months for example?