intarray index

Поиск
Список
Период
Сортировка
От Marek Lewczuk
Тема intarray index
Дата
Msg-id 438B52E3.3090002@lewczuk.com
обсуждение
Ответы Re: intarray index
BUG when migrating from 8.0 to 8.1 with create temp table
Список pgsql-general
Hello,
I have a question about IntArray contrib package. The docs says:
"...current implementation provides index support for one-dimensional
array of
int4's - gist__int_ops, suitable for small and medium size of arrays
(used on
default), and gist__intbig_ops for indexing large arrays (we use
superimposed
signature with length of 4096 bits to represent sets)..."

How many elements within single array is suggested within
small/medium/large array ? I have arrays with up to 200 elements - which
index I should use ?

Thanks.

ML



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