Re: Wraparound

From: Michael Banck <mbanck(at)gmx(dot)net>
To: Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Wraparound
Date: 2024-02-20 07:40:44
Message-ID: 20240220073955.GE13087@caipicrew.dd-dns.delightning.caipicrew.dd-dns.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

On Tue, Feb 20, 2024 at 10:02:02AM +0530, Rajesh Kumar wrote:
> Is autovacuum wraparound issue is when transaction id reaches
> autovacuum_freeze_max_age or if transaction Reaches 2^32.
>
> My autovacuum_freeze_age setting is 200million.

This is explained pretty well in the manual in my opinion:

https://www.postgresql.org/docs/current/routine-vacuuming.html#VACUUM-FOR-WRAPAROUND

Michael

In response to

  • Wraparound at 2024-02-20 04:32:02 from Rajesh Kumar

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2024-02-20 07:42:46 Re: Wraparound
Previous Message Rajesh Kumar 2024-02-20 07:27:45 Re: Wraparound