[HACKERS] LWLockAcquire with priority

2008-10-10 Thread Simon Riggs
Thinking about how to reduce the effects of certain race conditions makes me think about whether it is possible to make a function called LWLockAcquireWithPriority(). We already allow queue jumping when lock mode != LW_EXCLUSIVE, so queue jumping based upon an assigned priority rather than

Re: [HACKERS] LWLockAcquire with priority

2008-10-10 Thread Tom Lane
Simon Riggs [EMAIL PROTECTED] writes: This will prevent commits being stalled when we occasionally switch clog and multixact pages, plus it also stops commits from being stalled when there are heavy writers in progress. Exactly how would a priority mechanism prevent stalling? If the lock is