Re: Performance pb vs SQLServer.

From: Alvaro Herrera
Subject: Re: Performance pb vs SQLServer.
Date: ,
Msg-id: 20050815161859.GB22386@alvh.no-ip.org
(view: Whole thread, Raw)
In response to: Re: Performance pb vs SQLServer.  ("Magnus Hagander")
List: pgsql-performance

Tree view

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, )

On Mon, Aug 15, 2005 at 10:25:47AM +0200, Magnus Hagander wrote:

> SQL 2005 has "MVCC" (they call it something different, of course, but
> that's basicallyi what it is)

Interesting; do they use an overwriting storage manager like Oracle, or
a non-overwriting one like Postgres?

--
Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
"The Postgresql hackers have what I call a "NASA space shot" mentality.
 Quite refreshing in a world of "weekend drag racer" developers."
(Scott Marlowe)


pgsql-performance by date:

From: "Anjan Dave"
Date:
Subject: choosing RAID level for xlogs
From: "wisan watcharinporn"
Date:
Subject: database encoding with index search problem