Recovering disk space

From: stan <stanb(at)panix(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Recovering disk space
Date: 2019-10-10 07:57:00
Message-ID: 20191010075700.GA15483@panix.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message stan 2019-10-10 08:01:42 SOLVED Re: Recovering disk space
Previous Message Andres Freund 2019-10-10 07:18:45 Re: Segmentation fault with PG-12