Re: transaction ID wrap limit

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

 



"Sabin Coanda" <sabin.coanda@xxxxxxxxxxxxx> writes:
> A vacuum full command logs the message:
> ... LOG:  transaction ID wrap limit is 1073822617, limited by database "A"

> Sometimes ago, the vacuum full logged:
> ... LOG:  transaction ID wrap limit is 2147484148, limited by database "A"

> What causes that difference of the limit ?

The limit is *supposed* to advance.  The fact that it jumped this much
in one step suggests you're not vacuuming often enough :-(

			regards, tom lane


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux