25 days 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
25 days 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!
25 days 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
25 days 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.
25 days ago
nevermind, I figured out what happened in my case - problem in my application - wasn't idle after all.
Status changed to Solved gbahns • 25 days ago