Re: Performance pb vs SQLServer.

От: Qingqing Zhou
Тема: Re: Performance pb vs SQLServer.
Дата: ,
Msg-id: de1ikv$1k8r$1@news.hub.org
(см: обсуждение, исходный текст)
Ответ на: Re: Performance pb vs SQLServer.  ("Magnus Hagander")
Ответы: Re: Performance pb vs SQLServer.  (John A Meinel)
Список: pgsql-performance

Скрыть дерево обсуждения

Performance pb vs SQLServer.  (Stéphane COEZ, )
 Re: Performance pb vs SQLServer.  (John Arbash Meinel, )
  Re: Performance pb vs SQLServer.  ("Steinar H. Gunderson", )
   Re: Performance pb vs SQLServer.  (John Arbash Meinel, )
   Re: Performance pb vs SQLServer.  (Tom Lane, )
    Re: Performance pb vs SQLServer.  ("Steinar H. Gunderson", )
  Re: Performance pb vs SQLServer.  ("Steinar H. Gunderson", )
  Re: Performance pb vs SQLServer.  (Stéphane COEZ, )
 Re: Performance pb vs SQLServer.  (, )
  Re: Performance pb vs SQLServer.  (Stéphane COEZ, )
 Re: Performance pb vs SQLServer.  ("Magnus Hagander", )
  Re: Performance pb vs SQLServer.  (Stéphane COEZ, )
 Re: Performance pb vs SQLServer.  ("Magnus Hagander", )
  Re: Performance pb vs SQLServer.  (Alvaro Herrera <-ip.org>, )
  Re: Performance pb vs SQLServer.  ("Qingqing Zhou", )
   Re: Performance pb vs SQLServer.  (John A Meinel, )

"Alvaro Herrera" <-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 по дате сообщения:

От: John A Meinel
Дата:
Сообщение: Re: Performance pb vs SQLServer.
От: "Sebastian Lallana"
Дата:
Сообщение: FW: Tx forecast improving harware capabilities.