Re: meaning of (to prevent wraparound) ..??

From: Atul Kumar <akumar14871(at)gmail(dot)com>
To: Jessica Sharp <jessica(at)thesharpgeek(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: meaning of (to prevent wraparound) ..??
Date: 2020-11-26 06:09:30
Message-ID: CA+ONtZ5KHwvD+YPtqNsKoYYfvtBuQ3np7XNB3S_R_1gQEbbv5A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks Jessica. Could help me out by sharing documents that can help me
understand “to prevent wraparound “ in simplest way, postgres doc is little
bit harder for a newbee like me.

Regards
Atul

On Thursday, November 26, 2020, Jessica Sharp <jessica(at)thesharpgeek(dot)com>
wrote:

> Hi Atul,
>
> This means autovacuum is doing it’s job — most likely no need to be
> alarmed here based on this alone. The autovacuum is helping avoid a txid
> limit. This is part of PostgreSQL MVCC. You may check that section of the
> documentation for more information on this.
>
> On Wed, Nov 25, 2020 at 22:54 Atul Kumar <akumar14871(at)gmail(dot)com> wrote:
>
>> Hi,
>>
>> I have autovacuum running in background from last 30-40 minutes but I
>> noticed that it is with "(to prevent wraparound)" say for example
>> autovacuum: VACUUM trk.move (to prevent wraparound).
>>
>> So what is the meaning of "(to prevent wraparound)" here ?
>>
>> Will it impact the autovacuum anyhow ?
>>
>> Please help me.
>>
>>
>>
>> Regards,
>> Atul
>>
>>
>> --
> Kind regards,
> Jessica Sharp
> ---------------------
> (469) 602-2363
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jessica Sharp 2020-11-26 06:10:50 Re: meaning of (to prevent wraparound) ..??
Previous Message Jessica Sharp 2020-11-26 06:01:27 Re: meaning of (to prevent wraparound) ..??