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