Postgres Pro
Downloads
Home   >   mailing lists

Re: count * performance issue - Mailing list pgsql-performance

From Steinar H. Gunderson
Subject Re: count * performance issue
Date
Msg-id 20080306153639.GA19442@samfundet.no
Whole thread Raw
In response to Re: count * performance issue  (Craig James <craig_james@emolecules.com>)
Responses Re: count * performance issue
List pgsql-performance
Tree view 
On Thu, Mar 06, 2008 at 07:28:50AM -0800, Craig James wrote:
> Count() on Oracle and MySQL is almost instantaneous, even for very large
> tables. So why can't Postgres do what they do?

In MySQL's case: Handle transactions. (Try COUNT(*) on an InnoDB table.)

/* Steinar */
--
Homepage: http://www.sesse.net/

pgsql-performance by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: count * performance issue
Next
From: Bill Moran
Date:
Subject: Re: count * performance issue