10 months ago
New customer to Railway here and trying to understand why our Postgres instance continues to spike disk resources with our n8n instance. We have only 3 active workflows. I can't fathom how it's taking up 10GB of space.
Are there any optimization settings to minimize disk usage for Postgres?
4 Replies
10 months ago
Hey there! We've found the following might help you get unblocked faster:
- 🧵 How to decrease usage on n8n/postgres
- 🧵 No disk usage metrics since march 25th
- 🧵 Volume of Postgres is 96% full in production
If you find the answer from one of these, please let us know by solving the thread!
10 months ago
is this in the usage tab? that's incremental, so it might be right...I end up having huge amount of space/ram/cpu after a while...is the number in the metrics "normal"?
10 months ago
I think I found the issue – we have a workflow that crawls a 300+ page site. I added a few n8n variables to minimize logging.
I saw there are options to vacuum. Does Railway respect the env variables if I wanted to add autovacuum as config in the conf? Is there a better way to schedule this at off peak times?
austin
I think I found the issue – we have a workflow that crawls a 300+ page site. I added a few n8n variables to minimize logging. I saw there are options to vacuum. Does Railway respect the env variables if I wanted to add `autovacuum` as config in the conf? Is there a better way to schedule this at off peak times?
10 months ago
Respect the env vars for a postgres service? Yes Railway does respect those.
As for scheduling this, you could in theory setup a microservice to do this but it would heavily depend on the project and geared outcome.