From: Qingqing Zhou <zhouqq@cs.toronto.edu>
To: pgsql-performance@postgresql.org
Subject: Re: Performance pb vs SQLServer.
Date: Thu, 18 Aug 2005 16:56:41 +0800
Message-ID: <de1ikv$1k8r$1@news.hub.org> (raw)
References: <6BCB9D8A16AC4241919521715F4D8BCE6C789C@algol.sollentuna.se>
<20050815161859.GB22386@alvh.no-ip.org>
"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
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: zhouqq@cs.toronto.edu
Subject: Re: Performance pb vs SQLServer.
In-Reply-To: <de1ikv$1k8r$1@news.hub.org>
* 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