Anyway to index array with other columns

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


I think the answer is no, but I wanted to ask to be sure.

Given table below, is there any way to index  field_a, field_b, array_a?

Create table table1 (
field_a integer not null primary key,
field_b integer not null,
array_a text[]

My app is running queries similar to this:
Select * from table1 where field_a = 123 and field_b = 456 and array_a @> ARRAY[’tag_xyz’];

The array_a can have unto 1000 elements.  Currently these queries get very expensive if the array has any length to it.

Thanks for any ideas.


Chris Hoover
Senior DBA
Cell: (803) 528-2269
Email: chrish@xxxxxxxxxx

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux