Vacuumdb on a table
От | Murthy Nunna |
---|---|
Тема | Vacuumdb on a table |
Дата | |
Msg-id | DM8PR09MB66773DD56212C1EEF997ECDBB8D5A@DM8PR09MB6677.namprd09.prod.outlook.com обсуждение исходный текст |
Ответы |
Re: Vacuumdb on a table
Re: Vacuumdb on a table |
Список | 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!
В списке pgsql-admin по дате отправления: