Latest N8N on Kubernetes with 10 workers, Postgresql in its own dedicated DO Droplet managed under scalegrid.
Running N8N on a managed Postgresql at the moment, but the database is filling up significantly and clearing executions isnt working, need to truncate and vacuum the execution tables daily, something I dont recall ever having an issue with under our MySQL db setup prior to the change over.
I have some workflows that handle screenshots and PDF merging, seems to fill up the db fairly hard.
10gb per week.
What are people using?
Ideally a db connection configuration without SSL to make the kubernetes easier to config.
We run our db connections within a local VPN in the data centre
Alternatively, looking for a better way to clean up the executions - dont really like doing it from a db level as I dont know what files have been downloaded to the K8 volumes.