Re: intarray index
От | Oleg Bartunov |
---|---|
Тема | Re: intarray index |
Дата | |
Msg-id | Pine.GSO.4.63.0511290034510.29329@ra.sai.msu.su обсуждение исходный текст |
Ответ на | intarray index (Marek Lewczuk <newsy@lewczuk.com>) |
Список | pgsql-general |
On Mon, 28 Nov 2005, Marek Lewczuk wrote: > 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 ? gist__intbig_ops > > Thanks. > > ML > > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org > Regards, Oleg _____________________________________________________________ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83
В списке pgsql-general по дате отправления: