PostgreSQL database reaching 80% capacity at only 307 MB on Pro Plan - Incorrect storage limit

aaguilarpayjoy
PRO

3 months ago

Hello Railway Support Team,

I'm experiencing an issue with my PostgreSQL database storage limits that appears to be a configuration problem.

Issue Description:

My PostgreSQL database is showing 80% capacity usage, but the actual database size is only 307 MB. This suggests the storage limit is set to approximately 384 MB, which seems incorrect for a Pro Plan.

Current Setup:

- Plan: Railway Pro Plan

- Service: PostgreSQL (postgres.railway.internal)

- Database size: 307 MB (confirmed via pg_database_size query)

- Capacity warning: 80% full

Expected vs Actual:

- Expected: Pro Plan should have several GB of PostgreSQL storage

- Actual: Appears to be limited to ~384 MB (307 MB = 80%)

Technical Details:

- Database contains n8n workflow execution data (~1,322 execution records)

- VACUUM ANALYZE completed successfully with no size reduction

- No unusual table bloat or dead tuples detected

- 8 active connections (normal usage)

Queries Executed for Diagnosis:

```sql

SELECT pg_size_pretty(pg_database_size(current_database()));

-- Result: 307 MB

VACUUM ANALYZE;

-- Completed successfully, no size change

Solved$10 Bounty

7 Replies

3 months ago

Hey, did you create the database service while you were on the trial plan (500MB limit)? If this is the case, please try to grow the volume.


aaguilarpayjoy
PRO

3 months ago

I did create it while I was on a trial plan and the upgraded to hobby and then to pro, but it looks like I do have the resources updated , should I redeploy again for this values to be implemented?


aaguilarpayjoy

I did create it while I was on a trial plan and the upgraded to hobby and then to pro, but it looks like I do have the resources updated , should I redeploy again for this values to be implemented?

3 months ago

Hey, what you have shown is indeed correct. However, volume limits are not automatically applied when upgrading your plan. Please click on your volume and grow the volume in the volume settings.


aaguilarpayjoy
PRO

3 months ago

I don't see the option to increase volume just see the place in settings Resource Limits and there I already readjusted the memory and CPUs and hit redeploy but still showing 80% full, can you be more specific of where I can adjust this settings


aaguilarpayjoy

I don't see the option to increase volume just see the place in settings Resource Limits and there I already readjusted the memory and CPUs and hit redeploy but still showing 80% full, can you be more specific of where I can adjust this settings

3 months ago

Sure, no problem. You can grow the volume by clicking on the volume (the disk icon underneath your database/postgres service). I have attached a screenshot to show the volume settings, from where you can grow your volume.

Attachments


aaguilarpayjoy
PRO

3 months ago

done, thank you


aaguilarpayjoy

done, thank you

3 months ago

You are welcome!


Status changed to Solved uxuz 3 months ago


Status changed to Solved brody 3 months ago


PostgreSQL database reaching 80% capacity at only 307 MB on Pro Plan - Incorrect storage limit - Railway Help Station