From: | Jessica Sharp <jessica(at)thesharpgeek(dot)com> |
---|---|
To: | Atul Kumar <akumar14871(at)gmail(dot)com> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: meaning of (to prevent wraparound) ..?? |
Date: | 2020-11-26 06:10:50 |
Message-ID: | CAOUEXFQt=kozcjJ78jJSnMyskTe_bgTr61bP_wEoVBs5vGTb-g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Absolutely. This may be helpful:
https://youtu.be/bA1SgWn6Gv4
On Wed, Nov 25, 2020 at 23:09 Atul Kumar <akumar14871(at)gmail(dot)com> 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 <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
>>
> --
Kind regards,
Jessica Sharp
---------------------
(469) 602-2363
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2020-11-26 07:23:19 | Re: meaning of (to prevent wraparound) ..?? |
Previous Message | Atul Kumar | 2020-11-26 06:09:30 | Re: meaning of (to prevent wraparound) ..?? |