Re: VACUUM FREEZE vs plain VACUUM

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

To: Ron Johnson <ronljohnsonjr@xxxxxxxxx>
Subject: Re: VACUUM FREEZE vs plain VACUUM
From: "David G. Johnston" <david.g.johnston@xxxxxxxxx>
Date: Thu, 17 Jul 2025 20:27:58 -0700
Cc: pgsql-admin <pgsql-admin@xxxxxxxxxxxxxx>
In-reply-to: <CANzqJaCf-oSsFLkYivcwrGdj8mmZfnXqWYU_wvzk0OXZiYSW2w@mail.gmail.com>
References: <CANzqJaABg-S=qYnn7P2BzVzLYc2Z3WzE27Kw3=erT2KyC+F-LA@mail.gmail.com> <CAKFQuwZ=Rth-yv8Hdzv-z2tDRU-L1v93QAM1m9B_6oTA08b9OA@mail.gmail.com> <CANzqJaA6SPoy7ozSH3RQfJkRF1VTVwOYPmiBqH3p3cSb51tPng@mail.gmail.com> <CAKFQuwb7jVYNY2kNwjG6bYfoAJsf22cT2bYTAO6Xq_Ga7z-Ftg@mail.gmail.com> <CANzqJaCf-oSsFLkYivcwrGdj8mmZfnXqWYU_wvzk0OXZiYSW2w@mail.gmail.com>

On Thursday, July 17, 2025, Ron Johnson <ronljohnsonjr@xxxxxxxxx> wrote:

Even on that just-frozen, never-modified table, age(relfrozenxid) grows towards autovacuum_freeze_max_age.

I stand corrected. Of course pg_class.relfrozenxid wouldn’t continually change until an unfrozen tuple appeared…

David J.

References:
- VACUUM FREEZE vs plain VACUUM
  - From: Ron Johnson
- Re: VACUUM FREEZE vs plain VACUUM
  - From: David G. Johnston
- Re: VACUUM FREEZE vs plain VACUUM
  - From: Ron Johnson
- Re: VACUUM FREEZE vs plain VACUUM
  - From: David G. Johnston
- Re: VACUUM FREEZE vs plain VACUUM
  - From: Ron Johnson

Prev by Date: Re: VACUUM FREEZE vs plain VACUUM
Next by Date: Re: VACUUM FREEZE vs plain VACUUM
Previous by thread: Re: VACUUM FREEZE vs plain VACUUM
Next by thread: Re: VACUUM FREEZE vs plain VACUUM
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Home] [Postgresql General] [Postgresql Performance] [Postgresql PHP] [Postgresql Jobs] [PHP Users] [PHP Databases] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Yosemite Forum]

Powered by Linux