Re: MVCC and index-only read - Mailing list pgsql-general

From Scott Marlowe
Subject Re: MVCC and index-only read
Date
Msg-id dcc563d10811181209q12f10a18kaaf280e78649ace0@mail.gmail.com
Whole thread Raw
In response to Re: MVCC and index-only read  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Responses Re: MVCC and index-only read  ("Jonah H. Harris" <jonah.harris@gmail.com>)
Re: MVCC and index-only read  ("Daniel Verite" <daniel@manitou-mail.org>)
List pgsql-general
On Tue, Nov 18, 2008 at 1:07 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
> On Tue, Nov 18, 2008 at 1:03 PM, Jonah H. Harris <jonah.harris@gmail.com> wrote:
>> On Tue, Nov 18, 2008 at 2:57 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
>>> Sounds like they're borrowing the code from innodb that does much the
>>> same thing.  In Innodb, if a field is indexed, it lives only as an
>>> index, not in the table and an index at the same time.
>>
>> They aren't borrowing anything, Oracle has had this functionality
>> since at least Oracle 8i (1999).
>
> Whoa, calm down Francis.  I'm not suggesting they stole it or
> something.  Just that they're using the same basic concepts.

Oh, and citation needed.  I don't remember seeing anything about
oracle using indexes as sole storage units back in 8i


--
When fascism comes to America, it will be draped in a flag and
carrying a cross - Sinclair Lewis

pgsql-general by date:

Previous
From: "Jonah H. Harris"
Date:
Subject: Re: MVCC and index-only read
Next
From: "Jonah H. Harris"
Date:
Subject: Re: MVCC and index-only read