Storage allowance calculation bug?
Hi. I have 2 branches, one uses 51mb staorage, another 40mb. Cannot find anything else that could have used any storage.
But neon says i'm out of 0.5gb limit.
It looks like a bug because even in place where it says i used only 51mb limit is reached. See attached images.
Please confirm my db won'b deleted or frozen? 🙂
Project id snowy-water-29749332
5 Replies
genetic-orange•2mo ago
Hey! Do you have a restore window right now? To restore your database Neon needs to keep the WALs for that period of time, which takes some space.
genetic-orangeOP•2mo ago
why restore? you have a bug in your UI calculating 50mb as 500mb
genetic-orange•2mo ago
Because to enable restore, Neon keeps a history of changes that have happened to your database (the WALs). So, if your restore period is the full 1 day for free tier, and you just deleted a bunch of records, those will still chew up your space in the WALs until the restore period passes by.
Also, run vacuum full to reclaim some disk space.
genetic-orangeOP•2mo ago
Hi Sam, thank you for the reply! I actually have resotre enable with 1d selected - does it mean additionally to my 50mb DB it stores about 10 copies of it of the same size? I haven't found in the UI where i can check the space amount restore is taking - is it possible somehow?
genetic-orange•2mo ago
Unfortunately I don't know of a way to see how much storage the restore window is taking. Have you removed the restore? And did the vacuum give you enough storage to continue?