9 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:
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-a59ef2ddc40b15 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?
9 months ago
On the Hobby Plan, you have 5gb of storage
9 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?
9 months ago
How’s that postgresql volume looking like?
9 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.
9 months ago
For future reference, all you needed to do would be to grow the volume from 500mb to 5gb
9 months ago
Glad you fixed it! sorry for the late response I was AFK.
9 months ago
!s
Status changed to Solved medim • 9 months ago