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