"Thorne, Francis" <thornef@xxxxxxxxxxxxxx> writes: > Information in Log file after database restart > 01/08/2009 - Next Transaction ID = 1400435363 > 01/09/2009 - Next Transaction ID = 1462025864 > Transaction_ID Wrapwround limit is 214784146 limited by database > postgres > Is this normal, I would have thought the transactional ID would have > stayed roughly the same due to vacuum ? If this keeps increasing will it > mean I am getting to close my 2 billion transaction limit ? Yeah, this looks perfectly normal. VACUUM doesn't make the next-XID counter go backwards. What it will do from time to time is push out the wraparound limit (by "freezing" very old rows' XID numbers). As long as there's a few million transactions' worth of daylight between the wrap limit and current XIDs, there's nothing to worry about. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
