Recovering disk space
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
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
OOK, after a period of time, I recovered my disk space.
Stan, for those of us that have lost the ability to long distance mind
read, would you please
inform us of the steps you took to solve the problem? It might be helpful
in the future to someone
else in the same situation. It might also be useful to include the O/S and
PostgreSQL version.
On Thu, Oct 10, 2019 at 4:01 AM stan <stanb@panix.com> wrote:
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
--
*Melvin Davidson*
*Maj. Database & Exploration Specialist*
*Universe Exploration Command – UXC*
Employment by invitation only!
On Thu, Oct 10, 2019 at 3:57 AM stan <stanb@panix.com> wrote:
However, my 50G disk is still 96% full. How can I recover the disk space I
seem to have used u doing this?
The bloated storage is likely not under PostgreSQL's control. Use the
tools provided by your OS to figure out what is using the space.
Cheers,
Jeff