intarray index - Mailing list pgsql-general

From Marek Lewczuk
Subject intarray index
Date
Msg-id 438B52E3.3090002@lewczuk.com
Whole thread Raw
Responses Re: intarray index
BUG when migrating from 8.0 to 8.1 with create temp table
List 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 by date:

Previous
From: Jerry LeVan
Date:
Subject: ANN: PgBrowse-1.3 is available.
Next
From: Phong & Ronni Bounmixay
Date:
Subject: sub select as a data column