[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

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