Absolutely. This may be helpful:
https://youtu.be/bA1SgWn6Gv4
On Wed, Nov 25, 2020 at 23:09 Atul Kumar wrote:
> 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
> 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 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
>>
> --
Kind regards,
Jessica Sharp
-
(469) 602-2363
