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@xxxxxxxxxxx
