Search Postgresql Archives

Re: drop database

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx> 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@xxxxxxxxxxx> 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.'

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux