Re: [GENERAL] intarray index vs gin index

2007-02-09 Thread Teodor Sigaev
intarray. My question is whether I still should use intarray for indexing (if yes then either I should use GIST or GIN) or maybe GIN index is faster than GIST+intarray / GIN+intarray. Yes, with intarray you can use GiST/GIN indexes which you wish -- Teodor Sigaev

[GENERAL] intarray index vs gin index

2007-02-09 Thread Marek Lewczuk
Hello, I'm trying to update my database to 8.2 version and have some problems with intarray module. As far I know PG 8.2 contains many features that are contained within intarray - indexing array fields (using gin), operators etc. Currently (in PostgreSQL 8.1) I'm using intarray not only for i

Re: [GENERAL] intarray index

2005-11-28 Thread Oleg Bartunov
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__int

[GENERAL] intarray index

2005-11-28 Thread Marek Lewczuk
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 s