transaction ID wrap limit

From: "Sabin Coanda" <sabin(dot)coanda(at)deuromedia(dot)ro>
To: pgsql-performance(at)postgresql(dot)org
Subject: transaction ID wrap limit
Date: 2006-12-18 09:26:38
Message-ID: em5mse$e51$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Ron 2006-12-18 12:19:39 Re: New to PostgreSQL, performance considerations
Previous Message Tom Lane 2006-12-18 06:31:23 Re: Optimizing timestamp queries? Inefficient Overlaps?