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

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

In response to

Responses

Browse pgsql-general by date

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