>>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
In response to
pgsql-performance by date
|Next:||From: Craig A. James||Date: 2007-03-22 17:02:00|
|Subject: Re: Performance of count(*)|
|Previous:||From: David Brain||Date: 2007-03-22 16:30:22|
|Subject: Re: Potential memory usage issue|