From: Josh Berkus <josh@agliodbs.com>
Organization: PostgreSQL @ Sun
To: pgsql-performance@postgresql.org
Subject: Re: Array indexes, GIN?
Date: Thu, 1 Mar 2007 21:47:38 -0800
User-Agent: KMail/1.8.2
References: <45E7A108.9010802@mithral.com>
In-Reply-To: <45E7A108.9010802@mithral.com>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="utf-8"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200703012147.38414.josh@agliodbs.com>

Adam,

> On the surface, looks like a job for GIN, but GIN seems undocumented,
> specifically mentions it doesn't support the deletes we'll have many of
> since it's designed for word searching apparently, the performance
> implications are undocumented. I searched, I read, and even IRC'd, and
> it seems like GIN is just not used much.

It's new (as of 8.2).  And the authors, Oleg and Teodor, are notorious for 
skimpy documetentation.

I'd start with the code in INTARRAY contrib module (also by Teodor) and bug 
them on pgsql-hackers about helping you implement a GIN index for arrays.

-- 
Josh Berkus
PostgreSQL @ Sun
San Francisco