2 months ago
my database only has about 60MB of data but the volume was sized at about 240MB. then at 3:30 AM it started growing steadily until it hit the 500MB limit at about 1:00 PM, even though the application was idle. what's causing this?
I want to run a VACUUM operation or perform other maintenance on the database to get it back to under 100MB where it should be, but I can't connect to it due to it being in recovery mode. How do I work around this?
Thanks.
4 Replies
2 months ago
Hey there! We've found the following might help you get unblocked faster:
If you find the answer from one of these, please let us know by solving the thread!
2 months ago
this is my volume usage graph showing it start growing inexplicably at 3:30 AM until it hit the limit at about 1:12 PM
Attachments
2 months ago
I recovered by wiping my volume, restarting the postgresql server, which rebuilt the file system for an empty database, then I restored my latest backup (thankfully I've configured nightly backups). this brought me back to 200MB volume size for a data size of about 60MB. don't know what caused the volume to grow to 500MB+. will see if it happens again.
2 months ago
nevermind, I figured out what happened in my case - problem in my application - wasn't idle after all.
Status changed to Solved gbahns • about 2 months ago