Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Absolutely. This may be helpful: 
https://youtu.be/bA1SgWn6Gv4

On Wed, Nov 25, 2020 at 23:09 Atul Kumar <akumar14871@xxxxxxxxx> wrote:
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@xxxxxxxxxxxxxxxx> 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 <akumar14871@xxxxxxxxx> 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
--
Kind regards, 
Jessica Sharp
---------------------
(469) 602-2363

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux