Tom Lane wrote: > "Pavan Deolasee" <[EMAIL PROTECTED]> writes: > > Good point. I'm envisioning a procarray.c function along the > lines of > bool TransactionHasSnapshot(xid) > which returns true if the xid is currently listed in PGPROC > and has a nonzero xmin. CIC's cleanup wait loop would check > this and ignore the xid if it returns false. Your point means > that this function would have to take exclusive not shared lock > while scanning the procarray, which is kind of annoying, but > it seems not fatal since CIC isn't done all that frequently. >
Tom, If you haven't finished this yet, would you like me to work on this ? If I do it, I would mostly follow the path you suggested above, unless I run into something else. Thanks, Pavan -- EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match