Downloads
Home   >   mailing lists

Re: VACUUM FREEZE vs plain VACUUM - Mailing list pgsql-admin

From David G. Johnston
Subject Re: VACUUM FREEZE vs plain VACUUM
Date
Msg-id CAKFQuwZ2QYoaNw3NQLYZJ2m13K-ggB=DLUX-5Vv7v=W+pCzNVg@mail.gmail.com
Whole thread Raw
In response to Re: VACUUM FREEZE vs plain VACUUM  (Ron Johnson <ronljohnsonjr@gmail.com>)
List pgsql-admin
Tree view
On Thursday, July 17, 2025, Ron Johnson <ronljohnsonjr@gmail.com> 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.

pgsql-admin by date:

Previous
From: Ron Johnson
Date:
Subject: Re: VACUUM FREEZE vs plain VACUUM
Next
From: Laurenz Albe
Date:
Subject: Re: VACUUM FREEZE vs plain VACUUM