Postgres Pro
Downloads
Home   >   mailing lists

Re: Transaction ID's and Vacuum - Mailing list pgsql-admin

From Tom Lane
Subject Re: Transaction ID's and Vacuum
Date
Msg-id 29871.1289436389@sss.pgh.pa.us
Whole thread Raw
In response to Transaction ID's and Vacuum  (Samuel Stearns <SStearns@internode.com.au>)
List pgsql-admin
Tree view 
Samuel Stearns <SStearns@internode.com.au> writes:
> I've got an old 7.4.5 instance of Postgres running on Linux.  My transaction ID's are just over the 1 billion mark.
Iran an instance wide vacuum analyse but this had now effect on the transaction ID count.  Do I need to run a vacuum
full?

No.  There is no need to worry.  The transaction counter will march up
to 4 billion and then wrap around, if you keep the instance going that
long.  This is not a problem.

            regards, tom lane

pgsql-admin by date:

Previous
From: Samuel Stearns
Date:
Subject: Transaction ID's and Vacuum
Next
From:
Date:
Subject: kerberos issue with pgadmin3 in windows