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
>
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) ..?? |