Re: What kind of index to use for many rows with few unique

Поиск
Список
Период
Сортировка
От David F. Skoll
Тема Re: What kind of index to use for many rows with few unique
Дата
Msg-id Pine.LNX.4.50.0212021813470.6481-100000@shishi.roaringpenguin.com
обсуждение исходный текст
Ответ на Re: What kind of index to use for many rows with few unique values?  (Joel Burton <joel@joelburton.com>)
Ответы Re: What kind of index to use for many rows with few unique  (Joe Conway <mail@joeconway.com>)
Список pgsql-admin
Дерево обсуждения 
On Mon, 2 Dec 2002, Joel Burton wrote:

> Looks right to me: index scan for the less-common option, seqscan for
> the most common. Why don't you think this, as a btree, will work for
> you?

No, I'm sure a btree will work.  However, won't the index be
inefficient (i.e., very flat) if there are many entries with the same
value?  Or is this not a problem?

--
David.

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

Предыдущее
От: Joel Burton
Дата:
Сообщение: Re: What kind of index to use for many rows with few unique values?
Следующее
От: "Dan Langille"
Дата:
Сообщение: Re: What kind of index to use for many rows with few unique values?