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: (view raw, whole thread or download thread mbox)
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.


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-2018 The PostgreSQL Global Development Group