Thread: transaction ID wrap limit
Hi all, 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 ? Should I set or optimize something on my Postgresql server ? TIA, Sabin
"Sabin Coanda" <sabin.coanda@deuromedia.ro> 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