Обсуждение: 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!
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