Greg Stark wrote:
Tom Lane <[EMAIL PROTECTED]> writes:
Alvaro Herrera <[EMAIL PROTECTED]> writes:
On Fri, Apr 01, 2005 at 10:14:07PM -0500, Paul Tillotson wrote:
...
Well, at that point you need to take a lock in order to be able to
manage locks. Managing not to step on your own feet in that scenario
is complex, to say the least, if not downright impossible.
I looked at Paul's first message and thought "nah, that won't work
because ... because ... hmm ... hmmm ..."
For what it's worth, this would be very similar to how Oracle handles such
locks. In that case there's a fixed amount of space per page reserved in
advance for storing locks.
Actually I think it's a bit more complicated. But that's the idea.
While we're at it, does anyone know how DB2 and MSSQL server handle
row-level locks?
Paul
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
