PostgresError: No space left on device

My app keeps crashing when I hit 5GB of Memory usage. How can I increase this memory limit so my app doesn't crash? DatabaseError [PostgresError]: could not write to file "base/pgsql_tmp/pgsql_tmp5053.0": No space left on device
5 Replies
Percy
Percy6mo ago
Project ID: 1c4d6de5-39be-479a-a2e0-6d23824ccc0c
sweetman.eth
sweetman.eth6mo ago
project ID: 1c4d6de5-39be-479a-a2e0-6d23824ccc0c screenshot of the error
Brody
Brody6mo ago
that is talking about disk space on the volume of the database, not memory usage. the hobby plan is limited to 5gb volumes, you would need to upgrade to pro then you can grow your database volume to 50gb and then all should be back to normal
sweetman.eth
sweetman.eth6mo ago
oof $20 / month to increase db volume size? then I only get 10x increase? gonna start looking at other solutions 5GB is only 1 day of db usage for me sounds like Railway can't scale how we need
Brody
Brody6mo ago
if that doesn't suit your needs absolutely feel free to look for hosted database elsewhere, but you will have to pay egrees fees on that as opposed to no database to service egress fees when using the private network on railway. by the sounds of it, it doesn't seem like you plan on running a hobby workload, so that would require pro even if you didn't need 50gb volumes. once on pro you can always ask the team directly for further volume size increases.