10 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
10 months ago
Hey there! We've found the following might help you get unblocked faster:
- 🧵 Postgres DB full, can't connect
- 🧵 Worker out of memory
- 🧵 PostgreSQL Service Crash Loop - "No space left on device" with 99% Free Storage
If you find the answer from one of these, please let us know by solving the thread!
10 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
10 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.
10 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 • 10 months ago