Re: transactoin id wraparound problem - Mailing list pgsql-admin

From Tom Lane
Subject Re: transactoin id wraparound problem
Date
Msg-id 25552.1157580285@sss.pgh.pa.us
Whole thread Raw
In response to Re: transactoin id wraparound problem  (Scott Marlowe <smarlowe@g2switchworks.com>)
List pgsql-admin
Scott Marlowe <smarlowe@g2switchworks.com> writes:
> The most common cause of these problems is that you have long standing
> transactions that never get closed.

That can cause table bloat but it shouldn't have anything to do with XID
wraparound problems.  My guess is that the vacuum attempts are failing
somewhere along the line, and that some perusal of the postmaster log
would shed light on the issue.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Sriram Dandapani"
Date:
Subject: Re: transactoin id wraparound problem
Next
From: Tom Lane
Date:
Subject: Re: transactoin id wraparound problem