Re: count * performance issue

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: count * performance issue
Дата
Msg-id 200803061533.m26FXPe19222@momjian.us
обсуждение исходный текст
Ответ на Re: count * performance issue  (Craig James <craig_james@emolecules.com>)
Список 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 по дате отправления:

Предыдущее
От: Craig James
Дата:
Сообщение: Re: count * performance issue
Следующее
От: "Steinar H. Gunderson"
Дата:
Сообщение: Re: count * performance issue