Re: How are locks managed in PG? - Mailing list pgsql-general

From Jonah H. Harris
Subject Re: How are locks managed in PG?
Date
Msg-id 36e682920812211746h53b49961n3e5f5204a4b64d6e@mail.gmail.com
Whole thread Raw
In response to Re: How are locks managed in PG?  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: How are locks managed in PG?  (David Fetter <david@fetter.org>)
List pgsql-general
On Fri, Dec 19, 2008 at 7:49 AM, Alvaro Herrera
<alvherre@commandprompt.com> wrote:
>> Oracle on the other hand stores the lock information directly in the data
>> block that is locked, thus the number of locks does not affect system
>> performance (in terms of managing them).
>>
>> I couldn't find any description on which strategy PG applies.
>
> None of the above.  We're smarter than everyone else.

Which is why Oracle's locks are more scalable than PG's?

--
Jonah H. Harris, Senior DBA
myYearbook.com

pgsql-general by date:

Previous
From: Charles Duffy
Date:
Subject: Tracking down log segment corruption
Next
From: David Fetter
Date:
Subject: Re: How are locks managed in PG?