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

On 9/19/19 2:24 PM, Julie Nishimura wrote:
> Adrian,
> We do run vacuum w/o FULL every day:
> SYSTABLES="' pg_catalog.' || relname || ';' from pg_class a,
> pg_namespace b where a.relnamespace=b.oid and b.nspname='pg_catalog' an
> d a.relkind='r'"
>
> But it does not look like it frees up the space...
>
> Or you meant we need to run vacuum on 'my_db_name' without parameters,
> that it runs for every table? I am just not sure how long it will take
> to run for 39 tb...:(

Should have added to previous post that in this link:

https://www.postgresql.org/docs/8.2/routine-vacuuming.html#VACUUM-FOR-WRAPAROUND

there are some queries that can will show you the XID status for tables
and the database.

>
> Thanks

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com