Re: Performance pb vs SQLServer.

From: "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance pb vs SQLServer.
Date: 2005-08-18 08:56:41
Message-ID: de1ikv$1k8r$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


"Alvaro Herrera" <alvherre(at)alvh(dot)no-ip(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Jeff Trout 2005-08-18 13:00:31 Re: extremly low memory usage
Previous Message Ron 2005-08-18 03:19:04 Re: limit number of concurrent callers to a stored