R
Railwayβ€’12mo ago
sohcah

Database volume size

Hi, I've just attempted to move my database from Databases V1 to Databases V2 (manually, since I had problems using the automated solution on other projects... and I need to do it in a way which minimises downtime), and I've hit the 5GB database size limit on DB V2 whilst migrating my data. Can this 5GB limit be increased on the Hobby plan? Doubling the amount I'm paying to run my systems on Railway by upgrading to Pro isn't really an option for me at the moment - and I really don't want to have to move off of Railway.
23 Replies
Percy
Percyβ€’12mo ago
Project ID: 328a5f9d-67a9-4dd3-a605-143a716f788a
sohcah
sohcahβ€’12mo ago
328a5f9d-67a9-4dd3-a605-143a716f788a
Fragly
Fraglyβ€’12mo ago
Hobby plan is unfortunately limited to 5GB volume storage per service perhaps you could split the database up into multiple services or migrate to an external database
sohcah
sohcahβ€’12mo ago
It's just quite frustrating that I was previously able to easily fit within Railway's size limits, and this "better" V2 makes what I'm doing no longer possible.
Fragly
Fraglyβ€’12mo ago
that's understandable
sohcah
sohcahβ€’12mo ago
and splitting the database up isn't really an option. The majority of the storage is a single table with a few million records.
Fragly
Fraglyβ€’12mo ago
Dang, yea I don't see how you could solve this without either upgrading to pro or moving to an external database
sohcah
sohcahβ€’12mo ago
Yeah. I'd love to upgrade to Pro, but I'm trying to keep costs low, and Pro would almost double my spending (and if I kept other people having access, even more than double it)
Fragly
Fraglyβ€’12mo ago
Makes sense
sohcah
sohcahβ€’12mo ago
The good news is that most of this data isn't regularly accessed... so I'll undo what I've done so far with migrating and switch to only migrating the newest data. and figure out a proper solution later today, probably. :/ The most frustrating thing is the DB should only need ~3.5 GB (* according to postgres pg_database_size... but that might not be accurate), but actually copying the data across means it needs to store stuff in TMP files. Maybe I'll be able to move more of the data if I move it in smaller batches.
root
rootβ€’12mo ago
I'll flag for the team, this is good feedback
Duchess
Duchessβ€’12mo ago
Thread has been flagged to Railway team by @aleks.
sohcah
sohcahβ€’12mo ago
At the least - I think it would be worth updating Railway's pricing page to reflect this limitation. Currently, Persistent Storage is under "Included in all plans:", with a description which seems like it's not be updated to reflect the title of the card ("Unlimited inbound and 100GB of Outbound network. More if you need it.")
Brody
Brodyβ€’12mo ago
yeah that subtext is completely wrong for the header of persistent storage, I will definitely bring that up to the team, thank you
Ray
Rayβ€’12mo ago
cc @jr you're probably already aware, but heads up about plan-specific vol limits affecting migration
jr
jrβ€’12mo ago
Hi @sohcah, we can increase the size of your v2 database for you so that you are able to migrate. Do you know what size you need?
sohcah
sohcahβ€’12mo ago
Hi, For this project - I believe 10GB would be enough, but 15GB might be nice so that I've got enough room to run VACUUM on the table after I've finished migrating (which I can't do without enough free storage space to store the table twice). I've got other projects which might end up having similar issues when migrating, but in those cases I can probably reduce the database size (or afford to move to Pro for the project) πŸ™‚ Thanks!!
jr
jrβ€’12mo ago
No problem. And it is for the "Postgres" database in the project you linked? We can also increase the volume size in other projects if needed. We are discussing internally on how to consider this volume limit in general. But for now feel free to reach out to us if more size is needed
sohcah
sohcahβ€’12mo ago
Yep
jr
jrβ€’12mo ago
Is anything using the database? When I increase its size it there will be some downtime
sohcah
sohcahβ€’12mo ago
A few things are running with it, but nothing critical so happy with some downtime
jr
jrβ€’12mo ago
Cool. I'll update it to 20GB now updated and redeployed. You should be good to go
sohcah
sohcahβ€’12mo ago
Cheers. πŸ™‚
Want results from more Discord servers?
Add your server