Postgres Pro
Downloads
Home   >   mailing lists

Re: Performance pb vs SQLServer. - Mailing list pgsql-performance

From Qingqing Zhou
Subject Re: Performance pb vs SQLServer.
Date
Msg-id de1ikv$1k8r$1@news.hub.org
Whole thread Raw
In response to Re: Performance pb vs SQLServer.  ("Magnus Hagander" <mha@sollentuna.net>)
Responses Re: Performance pb vs SQLServer.
List pgsql-performance
Tree view 
"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

pgsql-performance by date:

Previous
From: Ron
Date:
Subject: Re: limit number of concurrent callers to a stored
Next
From: Jeff Trout
Date:
Subject: Re: extremly low memory usage