Re: transaction ID wrap limit

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Sabin Coanda" <sabin(dot)coanda(at)deuromedia(dot)ro>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: transaction ID wrap limit
Date: 2006-12-18 15:51:01
Message-ID: 9113.1166457061@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Sabin Coanda" <sabin(dot)coanda(at)deuromedia(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Harry Hehl 2006-12-18 16:32:19 Query plan changing when queried data does not
Previous Message Ron 2006-12-18 12:19:39 Re: New to PostgreSQL, performance considerations