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.klaver@aklaver.com