SOLVED Re: Recovering disk space - Mailing list pgsql-general

From stan
Subject SOLVED Re: Recovering disk space
Date
Msg-id 20191010080142.GA23150@panix.com
Whole thread Raw
In response to Recovering disk space  (stan <stanb@panix.com>)
Responses Re: SOLVED Re: Recovering disk space
List pgsql-general
OOK, after  a period of time, I recovered my disk space.

On Thu, Oct 10, 2019 at 03:57:00AM -0400, stan wrote:
> 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
> 
> 

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



pgsql-general by date:

Previous
From: stan
Date:
Subject: Recovering disk space
Next
From: Wim Bertels
Date:
Subject: Re: Is my lecturer wrong about PostgreSQL? I think he is!