Re: Wraparound

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Wraparound
Date: 2024-02-20 07:23:34
Message-ID: 11927075cfe167d8b64df7e767b595e27fabe3b0.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, 2024-02-20 at 10:02 +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.
>
> Db size is 150gb. 

2^31 is the magical number at which very old transactions become
transactions from the future, which would cause data loss unless
all old rows have been frozen.

Yours,
Laurenz Albe

In response to

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Rajesh Kumar 2024-02-20 07:27:45 Re: Wraparound
Previous Message Rajesh Kumar 2024-02-20 04:32:02 Wraparound