Vacuumdb on a table

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!

Responses

Browse pgsql-admin by date

  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?