Re: PostgreSQL vs. Microsoft SQL server

From: Greg Smith <greg(at)2ndquadrant(dot)com>
To: Scott Ribe <scott_ribe(at)killerbytes(dot)com>
Cc: Thomas Løcke <thomas(dot)granvej6(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: PostgreSQL vs. Microsoft SQL server
Date: 2010-05-01 23:16:57
Message-ID: 4BDCB669.6090201@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Scott Ribe wrote:
> PG's locking scheme, MVCC, basically precludes certain specific optimizations that means a small number of very specific queries don't perform as well, while at the same time it means that throughput with multiple simultaneous connections scales extremely well with multiple processors.
>

SQL Server uses MVCC too as of their 2005 release, implemented with row
versioning similarly to Postgres. The main non-MVCC holdout at this
point is DB2.

--
Greg Smith 2ndQuadrant US Baltimore, MD
PostgreSQL Training, Services and Support
greg(at)2ndQuadrant(dot)com www.2ndQuadrant.us

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Ribe 2010-05-01 23:30:10 Re: PostgreSQL vs. Microsoft SQL server
Previous Message Scott Ribe 2010-05-01 22:43:16 Re: PostgreSQL vs. Microsoft SQL server