intarray index

From: Marek Lewczuk <newsy(at)lewczuk(dot)com>
To: Lista dyskusyjna pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: intarray index
Date: 2005-11-28 18:56:35
Message-ID: 438B52E3.3090002@lewczuk.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Timothy Perrigo 2005-11-28 19:24:37 problem with psql?
Previous Message Jerry LeVan 2005-11-28 15:24:33 ANN: PgBrowse-1.3 is available.