Re: Indexing array columns.

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

 



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

[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