Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL vs. Microsoft SQL server - Mailing list pgsql-general

From Greg Smith
Subject Re: PostgreSQL vs. Microsoft SQL server
Date
Msg-id 4BDCB669.6090201@2ndquadrant.com
Whole thread Raw
In response to Re: PostgreSQL vs. Microsoft SQL server  (Scott Ribe <scott_ribe@killerbytes.com>)
Responses Re: PostgreSQL vs. Microsoft SQL server  (Scott Ribe <scott_ribe@killerbytes.com>)
Re: PostgreSQL vs. Microsoft SQL server  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-general
Tree view 
Scott Ribe wrote:
> PG's locking scheme, MVCC, basically precludes certain specific optimizations that means a small number of very
specificqueries don't perform as well, while at the same time it means that throughput with multiple simultaneous
connectionsscales 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@2ndQuadrant.com   www.2ndQuadrant.us

pgsql-general by date:

Previous
From: Scott Ribe
Date:
Subject: Re: PostgreSQL vs. Microsoft SQL server
Next
From: Scott Ribe
Date:
Subject: Re: PostgreSQL vs. Microsoft SQL server