I messed up and my disk utlization is HUGE

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

I messed up and my disk utlization is HUGE

stan-9
I was going to try to do some testing on very large databases, and I tried to
load the Mouse Gerome DB. It failed, and now I know why :-) I filled the
disk up. Presently, with virtually nothing in any database the postgres
storage location has 43G allocated. The DB was also crashed but i did free
up some space and get it started again. How can I shrink this back to a
reasonable size? The WAL also seems pretty large.



--
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
                                                -- Benjamin Franklin


Reply | Threaded
Open this post in threaded view
|

Re: I messed up and my disk utlization is HUGE

stan-9
On Wed, Oct 09, 2019 at 02:59:17PM -0400, melvin6925 wrote:
> Have you tried a VACUUM FULL of the db?Sent via the Samsung Galaxy S?? 6, an AT&T 4G LTE smartphone
> -------- Original message --------From: stan <[hidden email]> Date: 10/9/19  14:54  (GMT-05:00) To: melvin6925 <[hidden email]> Subject: Re: I messed up and my disk utlization is HUGE On Wed, Oct 09, 2019 at 01:30:33PM -0400, melvin6925 wrote:> >How can I shrink this back to a>reasonable size???Have you tried a vacuum full of the db?Sent via the Samsung Galaxy S?? 6, an AT&T 4G LTE smartphone> -------- Original message --------From: stan <[hidden email]> Date: 10/9/19?? 13:21?? (GMT-05:00) To: [hidden email] Subject: I messed up and my disk utlization is HUGE I was going to try to do some testing on very large databases, and I tried toload the Mouse Gerome DB. It failed, and now I know why :-) I filled thedisk up. Presently, with virtually nothing in any database the postgresstorage location has 43G allocated. The DB was also crashed but i did freeup some space and get it started again. How can I shrink this back to areasonable size? The WAL also seems pretty large.-- "They that would give up essential liberty for temporary safety deserveneither liberty nor safety." -- Benjamin FranklinSorry your reply was garbled.-- "They that would give up essential liberty for temporary safety deserveneither liberty nor safety." -- Benjamin Franklin

I ran vacuumdb from the comand line as postgres , which I beleive does
this. Did not take very long to run BTW.


--
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
                                                -- Benjamin Franklin