Re: [SQL] Yet Another (Simple) Case of Index not used

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: [SQL] Yet Another (Simple) Case of Index not used
Дата
Msg-id 20030420164609.GA30629@libertyrms.info
обсуждение исходный текст
Ответ на Re: [SQL] Yet Another (Simple) Case of Index not used  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
On Sun, Apr 20, 2003 at 11:21:32AM -0400, Tom Lane wrote:

> favor the other operations.  If you've designed an application that
> lives or dies by fast COUNT(*), perhaps you should choose another
> database.

Or consider redesigning the application.  The "no where clause"
restriction sure smacks of poor database normalisation to me.

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110


В списке pgsql-performance по дате отправления:

Предыдущее
От: Andreas Pflug
Дата:
Сообщение: Re: [SQL] Yet Another (Simple) Case of Index not used
Следующее
От: Ian Knopke
Дата:
Сообщение: problems