Indexing array columns.

From: Joshua Marsh <icub3d(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Indexing array columns.
Date: 2005-11-21 16:14:17
Message-ID: 38242de90511210814p62c88ad4w2a316b3fd1c7569f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jim C. Nasby 2005-11-21 16:43:42 Re: Batch Files
Previous Message Marcin Giedz 2005-11-21 15:59:58 Re: Server Hardware Configuration