Skip site navigation (1) Skip section navigation (2)

Re: Performance of count(*)

From: Carlos Moreno <moreno_pg(at)mochima(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Performance of count(*)
Date: 2007-03-22 16:58:45
Message-ID: 4602B5C5.20003@mochima.com (view raw or flat)
Thread:
Lists: pgsql-performance
>>count(*).  I was just discussing general performance issues on the
>>phone line and when my colleague asked me about the size of the
>>database he just wonderd why this takes so long for a job his
>>MS-SQL server is much faster.  [...].
>>    
>>
>
>Simple. MSSQL is optimized for this case, and uses "older"
>datastructures. PG uses a MVCC storage, 
>

Which version of MSSQL?  Wikipedia says that SQL Server 2005 uses the
MVCC model.

Carlos
--


In response to

pgsql-performance by date

Next:From: Craig A. JamesDate: 2007-03-22 17:02:00
Subject: Re: Performance of count(*)
Previous:From: David BrainDate: 2007-03-22 16:30:22
Subject: Re: Potential memory usage issue

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group