Indexing array columns.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux