Re: postgresql locks the whole table!

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: postgresql locks the whole table!
Дата
Msg-id 200312070937.hB79bAx00790@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: postgresql locks the whole table!  (Jeff Davis <jdavis-pgsql@empires.org>)
Ответы Re: postgresql locks the whole table!
Список 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 по дате отправления:

Предыдущее
От: Jeff Davis
Дата:
Сообщение: Re: postgresql locks the whole table!
Следующее
От: Chris Travers
Дата:
Сообщение: CREATE RULE problem/question requesting workaround