Re: URGENT: Performance tuning

Поиск
Список
Период
Сортировка
От Curt Sampson
Тема Re: URGENT: Performance tuning
Дата
Msg-id Pine.NEB.4.43.0206221822440.1091-100000@angelic.cynic.net
обсуждение исходный текст
Ответ на Re: URGENT: Performance tuning  (Ericson Smith <eric@did-it.com>)
Ответы Re: URGENT: Performance tuning  (Peter Dimov <jquest_j@yahoo.com>)
Список pgsql-general
On 20 Jun 2002, Ericson Smith wrote:

> For this purpose, you have to have indexes, yes.

Why? Given that there are only five values in the column in question
in a table with over a million rows, the selectivity of the index
would be so low I can't see how postgres would ever use it.

cjs
--
Curt Sampson  <cjs@cynic.net>   +81 90 7737 2974   http://www.netbsd.org
    Don't you know, in this new Dark Age, we're all light.  --XTC


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

Предыдущее
От: Curt Sampson
Дата:
Сообщение: Re: shared memory
Следующее
От: "Dave Page"
Дата:
Сообщение: Re: foreign Key problem