Re: postgresql locks the whole table! - Mailing list pgsql-general

From Bruce Momjian
Subject Re: postgresql locks the whole table!
Date
Msg-id 200312070937.hB79bAx00790@candle.pha.pa.us
Whole thread Raw
In response to Re: postgresql locks the whole table!  (Jeff Davis <jdavis-pgsql@empires.org>)
Responses Re: postgresql locks the whole table!
List pgsql-general
Jeff Davis wrote:
> The way I understand it, is that you're having trouble storing all of
> the xids in the row; right now you just store one and mark it "locked".
> If you were able to store several, but not necessarily all xids in all
> cases, wouldn't that be a big improvement? The xids not in the list
> would lock, as they do now, and the ones in the list would show an
> improvement by sharing the lock, right?
>
> Otherwise I don't entirely understand what you're saying.

Yes, we could do that but we really want something that isn't going to
work only some of the time.  Ideally we want something that can share no
matter how many backends try.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-general by date:

Previous
From: Jeff Davis
Date:
Subject: Re: postgresql locks the whole table!
Next
From: Chris Travers
Date:
Subject: CREATE RULE problem/question requesting workaround