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:01:27 |
Message-ID: | CAOUEXFREHqzDrQZdOo-jxtmbPLLkG+F5of-HOji6Dfjd9dxR7w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 | Atul Kumar | 2020-11-26 06:09:30 | Re: meaning of (to prevent wraparound) ..?? |
Previous Message | Atul Kumar | 2020-11-26 05:53:44 | meaning of (to prevent wraparound) ..?? |