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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend