Re: Indexing array columns.
This is a discussion on Re: Indexing array columns. within the pgsql Admins forums, part of the PostgreSQL category; --> Joshua Marsh wrote: > Does/Can the index track each element in the array, or does it track > only ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-10-2008, 05:31 AM
| ||||
| ||||
 Re: Indexing array columns. 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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq      |
Linear Mode
