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

Поиск
Список
Период
Сортировка
От Dan Langille
Тема Re: What kind of index to use for many rows with few unique
Дата
Msg-id 3DEBA506.20196.F87BE177@localhost
обсуждение исходный текст
Ответ на Re: What kind of index to use for many rows with few unique  (Joe Conway <mail@joeconway.com>)
Список pgsql-admin
Дерево обсуждения 
On 2 Dec 2002 at 15:15, Joe Conway wrote:

> David F. Skoll wrote:
> > 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?
> >
>
> If you're concerned, why not try a partial index?

FWIW, partial indexes didn't help for my distributions.  But btrees
were satisfactory.
--
Dan Langille : http://www.langille.org/

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

Предыдущее
От: Joe Conway
Дата:
Сообщение: Re: What kind of index to use for many rows with few unique
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pg_restore error: function plpgsql_call_handler already exists with same argument types