intarray index vs gin index

From: Marek Lewczuk <newsy(at)lewczuk(dot)com>
To: Lista dyskusyjna pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: intarray index vs gin index
Date: 2007-02-09 07:33:06
Message-ID: 45CC23B2.6090606@lewczuk.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 indexing (but this is the main feature) but also I'm using functions
(like count, sort...) and operators (+, -) that are provided by
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.

Thanks in advance for reply.
ML

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ashish Karalkar 2007-02-09 07:53:33 Automating databse creation
Previous Message johnf 2007-02-09 05:28:08 does anyone have a tool to convert SP'sT-SQL to Postgres