Re: is it safe to drop 25 tb schema with cascade option?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: Julie Nishimura <juliezain(at)hotmail(dot)com>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: is it safe to drop 25 tb schema with cascade option?
Date: 2019-09-19 21:55:27
Message-ID: 16068.1568930127@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> writes:
> So this is the part I need some clarification on. If you start vacuuming
> the tables that are setting the min then that should buy you some time?

Yes, if there are some small tables that have relfrozenxid even further
back than the big ones, vacuuming them first would be a win.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ron 2019-09-19 22:37:28 Re: is it safe to drop 25 tb schema with cascade option?
Previous Message Michael Lewis 2019-09-19 21:54:40 Re: FW: Re: FW: Re: Shouldn;t this trigger be called?