Re: [HACKERS] Shared row locking, revisited

2005-04-07 Thread Alvaro Herrera
On Thu, Apr 07, 2005 at 02:34:03PM +0800, Qingqing Zhou wrote: > > "Alvaro Herrera" <[EMAIL PROTECTED]> writes > > Because we can't reuse MultiXactIds at system crash (else we risk taking > > an Id which is already stored in some tuple), we need to XLog it. Not > > at the locking operation, becau

Re: [HACKERS] Shared row locking, revisited

2005-04-06 Thread Qingqing Zhou
"Alvaro Herrera" <[EMAIL PROTECTED]> writes > Because we can't reuse MultiXactIds at system crash (else we risk taking > an Id which is already stored in some tuple), we need to XLog it. Not > at the locking operation, because we don't want to log that one (too > expensive.) We can log the curre

[HACKERS] Shared row locking, revisited

2005-04-06 Thread Alvaro Herrera
Hackers, Again I come back to this topic. Now I have a better hold on an idea that is hopefully implementable and doesn't have expensive performance penalties. Forget the idea of using the regular lock manager directly on tuples. It's folly because we can't afford to have that many locks. Inste