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@xxxxxxxxx> Date: 10/9/19 14:54 (GMT-05:00) To: melvin6925 <melvin6925@xxxxxxxxx> 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@xxxxxxxxx> Date: 10/9/19?? 13:21?? (GMT-05:00) To: pgsql-general@xxxxxxxxxxxxxxxxxxxx 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
