Recovering disk space - Mailing list pgsql-general

From stan
Subject Recovering disk space
Date
Msg-id 20191010075700.GA15483@panix.com
Whole thread Raw
Responses SOLVED Re: Recovering disk space
Re: Recovering disk space
List pgsql-general
Sorry to repeat this, I am still in trouble on it.

I made the mistake of trying to import the mouse gnome database in an
effort to do some testing with very large data sets.

This import failed, probably because I ran out of disk space.  I deleted the
dump file, and a few other things, and now I have a bit of disk space.
Looks like I see the mad schema both in the postfres db, and in my own
stan db/ I did a drop schema cascade on both as the db superuser, and ran
vacuum full on both. This command came back almost instantly, which
surprises me.

However, my 50G disk is still 96% full. How can I recover the disk space I
seem to have used u doing this?


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



pgsql-general by date:

Previous
From: Andres Freund
Date:
Subject: Re: Segmentation fault with PG-12
Next
From: stan
Date:
Subject: SOLVED Re: Recovering disk space