Re: I messed up and my disk utlization is HUGE

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 <stanb(at)panix(dot)com> Date: 10/9/19 14:54 (GMT-05:00) To: melvin6925 <melvin6925(at)gmail(dot)com> 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 <stanb(at)panix(dot)com> Date: 10/9/19?? 13:21?? (GMT-05:00) To: pgsql-general(at)lists(dot)postgresql(dot)org 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