Re: drop database - Mailing list pgsql-general

From pabloa98
Subject Re: drop database
Date
Msg-id CAEjudX4Ybp1=jENVAOKMO2xLukCQkFFG1p0nex-dX5wk417WBg@mail.gmail.com
Whole thread Raw
In response to Re: drop database  (Andrew Kerber <andrew.kerber@gmail.com>)
List 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 by date:

Previous
From: Andrew Kerber
Date:
Subject: Re: drop database
Next
From: Олег Самойлов
Date:
Subject: stable for each row before insert trigger