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

From Tom Lane
Subject Re: [COMMITTERS] pgsql-server: Rearrange pg_subtrans handling as
Date
Msg-id 27284.1093316521@sss.pgh.pa.us
Whole thread Raw
In response to Re: [COMMITTERS] pgsql-server: Rearrange pg_subtrans handling as  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
Responses Re: [COMMITTERS] pgsql-server: Rearrange pg_subtrans handling  (Christopher Kings-Lynne <chriskl@familyhealth.com.au>)
List 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 by date:

Previous
From: Philip Warner
Date:
Subject: Re: New warning in pg_dump
Next
From: Alvaro Herrera
Date:
Subject: Re: pgsql-server: Rearrange pg_subtrans handling as