On Sat, 2007-03-24 at 11:48 -0400, Tom Lane wrote:
> Also, at some point a long-running transaction becomes a bottleneck
> simply because its XID is itself the oldest thing visible in the
> ProcArray and is determining everyone's xmin. How much daylight is
> there really between "your xmin is old" and "your xid is old"?
Hmm, yes. How often do we have an LRT that consists of multiple
statements of significant duration? Not often, I'd wager.
How much does it cost to optimise for this case?
Did Heikki's patch to move the xmin forward during VACUUM get rejected?
That seems like it has a much wider use case.
In response to
pgsql-patches by date
|Next:||From: Tom Lane||Date: 2007-03-26 19:40:29|
|Subject: Re: IDENTITY/GENERATED v36 Re: Final version of IDENTITY/GENERATED patch |
|Previous:||From: Simon Riggs||Date: 2007-03-26 19:27:11|
|Subject: Re: Improvement of procArray.xmin for VACUUM|