>>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
--