Re: How are locks managed in PG?

Поиск
Список
Период
Сортировка
От Jonah H. Harris
Тема Re: How are locks managed in PG?
Дата
Msg-id 36e682920812211746h53b49961n3e5f5204a4b64d6e@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How are locks managed in PG?  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: How are locks managed in PG?  (David Fetter <david@fetter.org>)
Список 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 по дате отправления:

Предыдущее
От: Charles Duffy
Дата:
Сообщение: Tracking down log segment corruption
Следующее
От: David Fetter
Дата:
Сообщение: Re: How are locks managed in PG?