Postgres Pro
Downloads
Home   >   mailing lists

Re: transaction ID wrap limit - Mailing list pgsql-performance

From Tom Lane
Subject Re: transaction ID wrap limit
Date
Msg-id 9113.1166457061@sss.pgh.pa.us
Whole thread Raw
In response to transaction ID wrap limit  ("Sabin Coanda" <sabin.coanda@deuromedia.ro>)
List pgsql-performance
Tree view 
"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

pgsql-performance by date:

Previous
From: Ron
Date:
Subject: Re: New to PostgreSQL, performance considerations
Next
From: "Harry Hehl"
Date:
Subject: Query plan changing when queried data does not