On Fri, 3 Mar 2023 at 23:43, Simon Elbaz <elbazsimon9@gmail.com> wrote: > hydrodb=# SELECT c.oid::regclass as table_name, > greatest(age(c.relfrozenxid),age(t.relfrozenxid)) as age > FROM pg_class c > LEFT JOIN pg_class t ON c.reltoastrelid = t.oid > WHERE c.relkind IN ('r', 'm') and c.relname='test'; > table_name | age > ------------+----- > test | 51 > (1 ligne) > > I expected it not to be processed by vacuum freeze. > However it has been entirely frozen.
You may have missed the wording in the docs about the FREEZE option. "Specifying FREEZE is equivalent to performing VACUUM with the vacuum_freeze_min_age and vacuum_freeze_table_age parameters set to zero." [0]
