Re: PG16devel - vacuum_freeze_table_age seems not being taken into account

On Fri, 3 Mar 2023 at 23:43, Simon Elbaz <elbazsimon9(at)gmail(dot)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]

David

[0] https://www.postgresql.org/docs/current/sql-vacuum.html