Re: PostgreSQL vs. Microsoft SQL server

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