On Jul 17, 2025, at 6:03 PM, Ron Johnson <ronljohnsonjr@gmail.com> wrote:
Does VACUUM FREEZE do something extra or special than to defer autovacuum for an extra 50,000,000 transactions?
Yes. Vacuum freeze removes the xmin on tuples that no longer need it. i.e. The xmin is not required by any other in-flight transaction.
I don’t know what you mean by defer auto vacuum. Vacuum freeze is a mechanism to recycle transaction ids; not to initiate an auto vacuum.
It sounds like you have autovacuum_freeze_max_age set too low for your environment.
i.e. Here is what I currently use:
autovacuum_freeze_max_age=800000000