From: | Murthy Nunna <mnunna(at)fnal(dot)gov> |
---|---|
To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Vacuumdb on a table |
Date: | 2023-10-18 20:05:53 |
Message-ID: | DM8PR09MB66773DD56212C1EEF997ECDBB8D5A@DM8PR09MB6677.namprd09.prod.outlook.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hi,
The first table in the following query resulted in age(c.relfrozenxid) = 148795396. But when I manually run vacuumdb command (vacuumdb -d db1 -t tab1) on that table it is not lowering the relfrozenxid. There is no indication in the pglog that vacuumdb failed.
SELECT c.oid::regclass
, age(c.relfrozenxid)
, pg_size_pretty(pg_total_relation_size(c.oid))
FROM pg_class c
JOIN pg_namespace n on c.relnamespace = n.oid
WHERE relkind IN ('r', 't', 'm')
AND n.nspname NOT IN ('pg_toast')
ORDER BY 2 DESC ;
I am wondering why vacuumdb is unable to lower relfrozenxid on this table? It seems to work on other tables though.
Thank you!
From | Date | Subject | |
---|---|---|---|
Next Message | Stephen Frost | 2023-10-18 20:47:13 | Re: What's the state of native Transparent Data Encryption (TDE) in PostgreSQL? |
Previous Message | richard coleman | 2023-10-18 19:36:20 | Re: What's the state of native Transparent Data Encryption (TDE) in PostgreSQL? |