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

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: (view raw or whole 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

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); ?




pgsql-admin by date

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

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