Re: SOLVED Re: Recovering disk space

Поиск
Список
Период
Сортировка
От Melvin Davidson
Тема Re: SOLVED Re: Recovering disk space
Дата
Msg-id CANu8FizNBrEpHTaVZv8HeGu+5tSXR2o6JM5Upxr7cVhirPzkmA@mail.gmail.com
обсуждение исходный текст
Ответ на SOLVED Re: Recovering disk space  (stan <stanb@panix.com>)
Список pgsql-general
>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!

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: psql \copy hanging
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Event Triggers and GRANT/REVOKE