Postgres Chewing Up Disk Space
austin
PROOP

3 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?

$10 Bounty

4 Replies

Railway
BOT

3 months ago

Hey there! We've found the following might help you get unblocked faster:

If you find the answer from one of these, please let us know by solving the thread!


fra
HOBBY

3 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"?


austin
PROOP

3 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?

noahd
EMPLOYEE

3 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.


Loading...