Re: Indexing array columns.

From: Joe Conway <mail(at)joeconway(dot)com>
To: Joshua Marsh <icub3d(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Indexing array columns.
Date: 2005-11-21 19:15:51
Message-ID: 43821CE7.4070508@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Joshua Marsh wrote:
> Does/Can the index track each element in the array, or does it track
> only the array as a whole?

Built in index support works on the array as a whole, not the individual
elements.

> How can I increase the speed of a query like: SELECT * FROM table WHERE
> 123 = ANY(array_of_ints); ?

See contrib/intarray.

Joe

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Michael D. Sofka 2005-11-21 20:36:24 Re: Server Hardware Configuration
Previous Message Brad Nicholson 2005-11-21 19:10:06 Re: Postgres Database slow