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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [COMMITTERS] pgsql-server: Rearrange pg_subtrans handling as
Дата
Msg-id 27284.1093316521@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [COMMITTERS] pgsql-server: Rearrange pg_subtrans handling as  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Ответы Re: [COMMITTERS] pgsql-server: Rearrange pg_subtrans handling  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Список pgsql-hackers
Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
> Just random speculation, but could we use a pg_subtrans-like setup to do 
> row share locks?

pg_subtrans is trivial to index --- it's a linear array subscripted by
TransactionId.  I'm not sure what we'd do to handle row locks, which
would need a key like (DBoid, RELoid, BlockNum, LineNum) and would be
extremely non-dense in that space.

'Tis something to think about though...
        regards, tom lane


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

Предыдущее
От: Philip Warner
Дата:
Сообщение: Re: New warning in pg_dump
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: pgsql-server: Rearrange pg_subtrans handling as