Re: temporary data after diskspace error

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: temporary data after diskspace error
Дата
Msg-id 20278.1580159703@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: temporary data after diskspace error  (Willy-Bas Loos <willybas@gmail.com>)
Ответы Re: temporary data after diskspace error
Список pgsql-general
Willy-Bas Loos <willybas@gmail.com> writes:
> Will there be a lot of downtime to delete those 90GB of temp files?
> Will postgres just delete those files without processing them or should I
> brace for some downtime?

It's just a directory scan and an unlink() for each file that has
the right filename pattern to be a temp file.  If you've got a
reasonable filesystem I wouldn't expect it to take long.
Maybe a minute? (but don't quote me on that)

            regards, tom lane



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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: How to transfer databases form one server to other
Следующее
От: basti
Дата:
Сообщение: Re: How to transfer databases form one server to other