Re: transactoin id wraparound problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
Cc: Sriram Dandapani <sdandapani(at)counterpane(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: transactoin id wraparound problem
Date: 2006-09-06 22:04:45
Message-ID: 25552.1157580285@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Scott Marlowe <smarlowe(at)g2switchworks(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2006-09-06 22:10:36 Re: transactoin id wraparound problem
Previous Message Scott Marlowe 2006-09-06 21:18:16 Re: transactoin id wraparound problem