(Incorrect?) Exceeding Storage Limit on Free Tier
Dear,
Currently I am working on a project using the Neon Tech free tier. Unfortunately I think an error has occured thinking I exceeded the storage limit for my tier. When I look at storage in Account Usage it states that I used 0.52/0.47 GiB but when 1 look at the Review Usage tab I can see that I only used 0.01/0.5 GB per month. Is this indeed an error or did I do something wrong? I would love to hear from you.
Kind regards,
Quin
my project id:
27 Replies
ratty-blush•12mo ago
Hey! Thank you for reporting this issue. Are you still running into it?
adverse-sapphireOP•12mo ago
Hi Mahmoud, I still have the same issue
ratty-blush•12mo ago
to make sure I understand correctly, you're able to write data to your database, correct? You're not getting any errors?
adverse-sapphireOP•12mo ago
I am not able to write into the database, read operations are coming through tho
ratty-blush•12mo ago
What happens when you run
SELECT pg_size_pretty(pg_database_size('neondb'));adverse-sapphireOP•12mo ago
adverse-sapphireOP•12mo ago
adverse-sapphireOP•12mo ago
This is the result of the following command
ratty-blush•12mo ago
I'll reach out internally and get back to you. Feel free to ping me if I'm gone too long
adverse-sapphireOP•12mo ago
Alright, Thank you!
ratty-blush•12mo ago
So Neon storage consists of two main components:
1. Data Size: this is the size of the data you're storing
2. History: this is a log of changes (inserts, updates, and deletes) to your data over time in the form of Write-Ahead Log (WAL) records. History enables point-in-time restore, time travel queries, and branching features.
It seems that you made lots of changes, which resulted in you reaching the free tier storage limit
adverse-sapphireOP•12mo ago
That is correct, I added two columns but it affected only 58 rows
I cannot find this anywhere
Also I am not sure how this happend if this is indeed the case
adverse-sapphireOP•12mo ago
ratty-blush•12mo ago
Yea unfortunately the console currently doesn't expose a detailed breakdown. This is something we're actively working on improving
I understand that the behavior is surprising and is frustrating
adverse-sapphireOP•12mo ago
I just cannot believe I have used this much storage, also with the changes kept in mind. Do you know when this limit will be reset?
adverse-sapphireOP•12mo ago
ratty-blush•12mo ago
I'm checking in internally and will get back to you 🫡
adverse-sapphireOP•12mo ago
Did you have any chance getting a look into this?
@Mahmoud?
ratty-blush•12mo ago
Hey! so if you go to your project settings. Under the storage option, you can set the history retention to zero. This should free up storage space and you should be able to write more data to your project
ratty-blush•12mo ago
Could you try this and let me know if the issue persists?
adverse-sapphireOP•12mo ago
I just updated the retention setting. I will let you know if the issue persists
It still does not allow for new database write operations unfortunately
adverse-sapphireOP•12mo ago
This did update
adverse-sapphireOP•12mo ago
adverse-sapphireOP•12mo ago
But it still shows I am over the limit
@Mahmoud
ratty-blush•12mo ago
Can you try again? We just triggered a compute restart for your project which should fix the issue
adverse-sapphireOP•12mo ago
Thank you so much, this helped!
@Mahmoud Thanks for helping me today!
ratty-blush•12mo ago
Awesome! I appreciate your patience and apologies for the inconvenience
Feel free to reach out if you have any questions or run into any issues