Railway provisioned PostgreSQL DB is only returning size of 9.45 MB. Was expecting 32gb
Hey Team, I asked in the #📚｜new-to-programming channel the q of what is the default size for the PSQL DB Railway provides since it's not able to be found anywhere (ss attached). Was told it was 32gb. I just ran a
SELECT pg_size_pretty(pg_database_size('railway')); to check the size myself and am only getting 9453KB being returned (ss attached). Any thoughts? Thanks in advance -> currently analyzing between heroku vs railway PSQL DB
Thanks in advance!
5 Replies
Project ID:
0b864ce0-6308-4b48-a8b6-e1ff7247690e0b864ce0-6308-4b48-a8b6-e1ff7247690e
32gb is the size of the volume the database plugins get, I was told this by a team member
as for this
pg_size variable, I have no clue what that number represents but its not returning the volume size
the database plugins as you know them will be deprecated at some point in the future so that does mean your v2 databases will get a 5gb volume on hobby and a 50gb volume on pro
for new projects, it might not be a good idea to use the official database templates that are just a docker image and a volume so that you don't have to migrate down the lineYou're the man. This makes total sense. Newbie mistake on my part -> didn't realize Volume was the keyword to represent DB pricing size in the help docs.
Also, I figured out that the sql command used above is for how much disk space is being used not total volume.
Really kind insight - I'll aim to do just that to avoid the migration in the future.
Overall, thank you very very much for being such an active supporter of the railway community. You've amazing Mr. Brody ty again
thank you, your kind words mean a lot 🙂