Home > mailing lists

Indexing array columns. - Mailing list pgsql-admin

From	Joshua Marsh
Subject	Indexing array columns.
Date	November 21, 2005 15:14:28
Msg-id	38242de90511210814p62c88ad4w2a316b3fd1c7569f@mail.gmail.com Whole thread Raw
Responses	Re: Indexing array columns. (Joe Conway <mail@joeconway.com>)
List	pgsql-admin

Tree view

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:

From: Marcin Giedz
Date: 21 November 2005, 15:00:16
Subject: Re: Server Hardware Configuration

From:
Date: 21 November 2005, 15:15:32
Subject: Batch Files

Indexing array columns. - Mailing list pgsql-admin

Previous

Next