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 по дате отправления: