3 months ago
I'm trying to mass insert rows into a PostGreSQL database. I have the "Hobby" plan, and my database is configured to have the maximum 8GB of space. However, after inserting only about 40k rows, I get this error in python:psycopg2.errors.DiskFull: could not extend file "base/16384/16403": No space left on device HINT: Check free disk space.
However, I used "railway conect" to check the database storage, and got the following output:railway=# \dt+ List of relations Schema | Name | Type | Owner | Persistence | Access method | Size | Description --------+--------+-------+----------+-------------+---------------+--------+------------- public | labels | table | postgres | permanent | heap | 200 MB | public | user | table | postgres | permanent | heap | 16 kB | (2 rows)
I don't understand how I could be even close to 8gb of storage, even when considering overheads.
How do I get the storage I paid for?
Project ID is 45f53a74-66df-42ae-bbe2-a59ef2ddc40b
0 Replies
@Railway , I do have a rather time-sensitive need to get this data accessible, so I'd appreciate any help possible. Thanks.
Project ID is 45f53a74-66df-42ae-bbe2-a59ef2ddc40b
@Chandrika @Medim apologies for the ping, but I've been looking on the website and I'm getting pretty confused about what could be causing this. Should I try filing a support ticket anywhere else?
3 months ago
On the Hobby Plan, you have 5gb of storage
3 months ago
Not 8gb, you’re confusing it with RAM
Oh, that's my bad. Regardless, I don't think I'm anywhere near 5gb either, do you know what could cause this error?
3 months ago
How’s that postgresql volume looking like?
3 months ago
Click it on the dashboard and share the usage here please.
what's odd is that it doesn't seem to have any info from when I started adding stuff onward
it ends at 12:40pm, I started adding data at around 1pm but its 4pm now
you know, i think i may have an idea for how to try again, give mea minute.
alright, i tried deleting the volume and creating a new one, and it seems to be handling more(?) sorry for the trouble. i wonder if it has something to do with me upgrading to the hobby plan after initially creating it? but anyways, thanks for your help.
3 months ago
For future reference, all you needed to do would be to grow the volume from 500mb to 5gb
3 months ago
Glad you fixed it! sorry for the late response I was AFK.
3 months ago
!s
Status changed to Solved medim • 3 months ago