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

Re: arrays and indexes

From: Pierre-Frédéric Caillaud <lists(at)boutiquenumerique(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: arrays and indexes
Date: 2004-07-26 20:35:01
Message-ID: opsbrh4nu4cq72hf@musicbox (view raw or flat)
Thread:
Lists: pgsql-performance
>> > SELECT * from content where 42 = ANY (authors);

>> Postgres does have a way to do what you ask, though. It involves GiST
>> indexes and the operators from the contrib/intarray directory from the
>> Postgres source.

	I have tried to use these indexes, and the performance was very good. It
can be faster (in fact much faster) than a join with an additional table,
because you don't have a join. The SQL array syntax is a pain, though.

In response to

pgsql-performance by date

Next:From: Greg StarkDate: 2004-07-26 20:40:32
Subject: Re: arrays and indexes
Previous:From: Ross J. ReedstromDate: 2004-07-26 18:47:03
Subject: Re: arrays and indexes

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