Re: [COMMITTERS] pgsql-server: Rearrange pg_subtrans handling

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: [COMMITTERS] pgsql-server: Rearrange pg_subtrans handling
Дата
Msg-id 412ACB38.5050907@familyhealth.com.au
обсуждение исходный текст
Ответ на Re: [COMMITTERS] pgsql-server: Rearrange pg_subtrans handling as  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: [COMMITTERS] pgsql-server: Rearrange pg_subtrans  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
Re: [COMMITTERS] pgsql-server: Rearrange pg_subtrans handling  (Richard Huxton <dev@archonet.com>)
Список pgsql-hackers
> Uh ... the interesting question is usually not "does this backend hold
> any row locks", it is "is this row locked by any backends".  If the
> latter question is not *exceedingly* cheap to answer, at least in the
> normal case where the answer is no, you don't have a workable solution,
> because you'll be adding nontrivial overhead to every row update.

OK, what I mean is to know if a row is locked by any backend, why can't 
we just put a reference count of the number of locks on that row, 
instead of recording each backend separately?  Wouldn't that require a 
fixed amount of shared mem?

Chris



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [COMMITTERS] pgsql-server: Rearrange pg_subtrans handling as
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: [COMMITTERS] pgsql-server: Rearrange pg_subtrans