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

From Bruce Momjian
Subject Re: count * performance issue
Date
Msg-id 200803061533.m26FXPe19222@momjian.us
Whole thread Raw
In response to Re: count * performance issue  (Craig James <craig_james@emolecules.com>)
List pgsql-performance
Craig James wrote:
> This is a real problem.  Countless people (including me) have
> spent significant effort rewriting applications because of this
> performance flaw in Postgres.  Over and over, the response is,
> "You don't really need to do that ... change your application."
> Well, sure, it's always possible to change the application, but
> that misses the point.  To most of us users, count() seems like
> it should be a trivial operation.  On other relational database
> systems, it is a trivial operation.
>
> This is really a significant flaw on an otherwise excellent
> relational database system.

Have you read the TODO items related to this?

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://postgres.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

pgsql-performance by date:

Previous
From: Craig James
Date:
Subject: Re: count * performance issue
Next
From: "Steinar H. Gunderson"
Date:
Subject: Re: count * performance issue