Re: How are locks managed in PG?

From: "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
To: "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>
Cc: "Thomas Kellerer" <spam_eater(at)gmx(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: How are locks managed in PG?
Date: 2008-12-22 01:46:15
Message-ID: 36e682920812211746h53b49961n3e5f5204a4b64d6e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Dec 19, 2008 at 7:49 AM, Alvaro Herrera
<alvherre(at)commandprompt(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Fetter 2008-12-22 02:42:58 Re: How are locks managed in PG?
Previous Message Charles Duffy 2008-12-22 00:16:28 Tracking down log segment corruption