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

From Tom Lane
Subject Re: count * performance issue
Date
Msg-id 18451.1204824562@sss.pgh.pa.us
Whole thread Raw
In response to Re: count * performance issue  (Craig James <craig_james@emolecules.com>)
Responses Re: count * performance issue  (Craig James <craig_james@emolecules.com>)
Re: count * performance issue  (Josh Berkus <josh@agliodbs.com>)
List pgsql-performance
Craig James <craig_james@emolecules.com> writes:
> Count() on Oracle and MySQL is almost instantaneous, even for very large tables. So why can't Postgres do what they
do?

AFAIK the above claim is false for Oracle.  They have the same
transactional issues we do.

            regards, tom lane

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Why the difference in plans ?
Next
From: Tom Lane
Date:
Subject: Re: Performance of aggregates over set-returning functions