Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group