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 <jess...@thesharpgeek.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 <akumar14...@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 >
