Re: drop database

Поиск
Список
Период
Сортировка
От pabloa98
Тема Re: drop database
Дата
Msg-id CAEjudX4Ybp1=jENVAOKMO2xLukCQkFFG1p0nex-dX5wk417WBg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: drop database  (Andrew Kerber <andrew.kerber@gmail.com>)
Список pgsql-general
Perhaps you want to TRUNCATE TABLEs. That will mitigate any I/O impact


On Thu, Oct 17, 2019 at 3:13 PM Andrew Kerber <andrew.kerber@gmail.com> wrote:
If you are decommissioning the database, why not just rm -rf the whole system?

On Thu, Oct 17, 2019 at 4:31 PM Michael Lewis <mlewis@entrata.com> wrote:
Your plan to loop over tables and truncate them seems great if you are worried. It seems simple to verify that space is being freed as you go, and also easy to change tactics if the need arises.


--
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

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

Предыдущее
От: Andrew Kerber
Дата:
Сообщение: Re: drop database
Следующее
От: Олег Самойлов
Дата:
Сообщение: stable for each row before insert trigger