Postgres Pro
Downloads
Home   >   mailing lists

Re: meaning of (to prevent wraparound) ..?? - Mailing list pgsql-general

From Jessica Sharp
Subject Re: meaning of (to prevent wraparound) ..??
Date
Msg-id CAOUEXFREHqzDrQZdOo-jxtmbPLLkG+F5of-HOji6Dfjd9dxR7w@mail.gmail.com
Whole thread Raw
In response to meaning of (to prevent wraparound) ..??  (Atul Kumar <akumar14871@gmail.com>)
Responses Re: meaning of (to prevent wraparound) ..??  (Atul Kumar <akumar14871@gmail.com>)
List pgsql-general
Tree view
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@gmail.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

pgsql-general by date:

Previous
From: Atul Kumar
Date:
Subject: meaning of (to prevent wraparound) ..??
Next
From: Atul Kumar
Date:
Subject: Re: meaning of (to prevent wraparound) ..??