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 36e682920812211948gb39e6b9ic3904d62494cb404@mail.gmail.com
Whole thread Raw
In response to Re: How are locks managed in PG?  (David Fetter <david@fetter.org>)
Responses Re: How are locks managed in PG?  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-general
On Sun, Dec 21, 2008 at 9:42 PM, David Fetter <david@fetter.org> wrote:
> On Sun, Dec 21, 2008 at 08:46:15PM -0500, Jonah H. Harris wrote:
>> 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?
>
> You've been talking about your super-secret test which you allege,
> quite implausibly, I might add, to have Oracle (8i, even!) blowing
> PostgreSQL's doors off for weeks now.
>
> Put up, or shut up.

Same to the standard PG B.S. responses such as, "None of the above.
We're smarter than everyone else."  When's the last time Alvaro used
or tuned Oracle?  Does he have a clue about how Oracle locks scale?
Stop complaining.

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

pgsql-general by date:

Previous
From: David Fetter
Date:
Subject: Re: How are locks managed in PG?
Next
From: "Scott Marlowe"
Date:
Subject: Re: How are locks managed in PG?