Search Postgresql Archives

Re: PG16devel - vacuum_freeze_table_age seems not being taken into account

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I ran vacuum without the freeze option as you can see below.

Simon

On Fri, Mar 3, 2023 at 12:01 PM David Rowley <dgrowleyml@xxxxxxxxx> wrote:
On Fri, 3 Mar 2023 at 23:43, Simon Elbaz <elbazsimon9@xxxxxxxxx> 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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux