Re: Indexing array columns. - Mailing list 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