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@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.
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