Indexing array columns. - Mailing list pgsql-admin

From Joshua Marsh
Subject Indexing array columns.
Date
Msg-id 38242de90511210814p62c88ad4w2a316b3fd1c7569f@mail.gmail.com
Whole thread Raw
Responses Re: Indexing array columns.
List pgsql-admin
I've been searching the manual looking for information about the effects of indexing an array column but haven't found any information as of yet. 

Does anyone have any information on how the indexes work for arrayed columns? 

Does/Can the index track each element in the array, or does it track only the array as a whole? 

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

Thanks,

Josh

pgsql-admin by date:

Previous
From: Marcin Giedz
Date:
Subject: Re: Server Hardware Configuration
Next
From:
Date:
Subject: Batch Files