Skip site navigation (1) Skip section navigation (2)

Re: index usage on arrays

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: andrew klassen <aptklassen(at)yahoo(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: index usage on arrays
Date: 2008-02-07 19:01:58
Message-ID: 8143.1202410918@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
andrew klassen <aptklassen(at)yahoo(dot)com> writes:
> Is there any alternative to what am I currently doing other than creating a row for 
> each array element,

Since (I think) 8.2, you could create a GIN index on the array column
and then array overlap (&&) would be indexable.  GIN has some
performance issues if the table is heavily updated, though.

			regards, tom lane

In response to

pgsql-performance by date

Next:From: Yonatan Ben-NesDate: 2008-02-08 12:12:09
Subject: Wrong number of rows estimation by the planner
Previous:From: Oleg BartunovDate: 2008-02-07 18:55:44
Subject: Re: index usage on arrays

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group