Postgres Pro
Downloads
Home   >   mailing lists

Re: is it safe to drop 25 tb schema with cascade option? - Mailing list pgsql-general

From Tom Lane
Subject Re: is it safe to drop 25 tb schema with cascade option?
Date
Msg-id 16068.1568930127@sss.pgh.pa.us
Whole thread Raw
In response to Re: is it safe to drop 25 tb schema with cascade option?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: is it safe to drop 25 tb schema with cascade option?
List pgsql-general
Tree view 
Adrian Klaver <adrian.klaver@aklaver.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

pgsql-general by date:

Previous
From: Michael Lewis
Date:
Subject: Re: FW: Re: FW: Re: Shouldn;t this trigger be called?
Next
From: Ron
Date:
Subject: Re: is it safe to drop 25 tb schema with cascade option?