From: John A Meinel <john@arbash-meinel.com>
To: Qingqing Zhou <zhouqq@cs.toronto.edu>
Cc: pgsql-performance@postgresql.org
Subject: Re: Performance pb vs SQLServer.
Date: Thu, 18 Aug 2005 09:44:34 -0500
Message-ID: <43049ED2.1080606@arbash-meinel.com> (raw)
In-Reply-To: <de1ikv$1k8r$1@news.hub.org>
References: <6BCB9D8A16AC4241919521715F4D8BCE6C789C@algol.sollentuna.se>
<20050815161859.GB22386@alvh.no-ip.org>
<de1ikv$1k8r$1@news.hub.org>
Qingqing Zhou wrote:
> "Alvaro Herrera" <alvherre@alvh.no-ip.org> writes
>
>>Interesting; do they use an overwriting storage manager like Oracle, or
>>a non-overwriting one like Postgres?
>>
>
>
> They call this MVCC "RLV(row level versioning)". I think they use rollback
> segment like Oracle (a.k.a "version store" or tempdb in SQL Server). Some
> details are explained in their white paper:"Database concurrency and row
> level versioning in SQL Server 2005".
>
> Regards,
> Qingqing
>
I found the paper here:
http://www.microsoft.com/technet/prodtechnol/sql/2005/cncrrncy.mspx
And it does sound like they are doing it the Oracle way:
When a record in a table or index is updated, the new record is stamped
with the transaction sequence_number of the transaction that is doing
the update. The previous version of the record is stored in the version
store, and the new record contains a pointer to the old record in the
version store. Old records in the version store may contain pointers to
even older versions. All the old versions of a particular record are
chained in a linked list, and SQL Server may need to follow several
pointers in a list to reach the right version. Version records need to
be kept in the version store only as long as there are there are
operations that might require them.
John
=:->
Attachments:
signature.asc (application/pgp-signature, 252B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: john@arbash-meinel.com, zhouqq@cs.toronto.edu
Subject: Re: Performance pb vs SQLServer.
In-Reply-To: <43049ED2.1080606@arbash-meinel.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox