postgresql - What kind of index should I create to make "WHERE col1 LIKE '0000%' AND col2 = 'somevalue'" faster? - i tried next queries in order search within quad tree using postgresql's like operator. in column col3 , there words '0133002112300300320' inserted, describes quad tree's path. create table table1 (col1 character(9) not null, col2 integer not null, col3 character varying(64), col4 integer not null, col5 double precision not null, primary key(col1,col2,col3)); -- performs sequential search select col1,col2,col3,col4,col5 table1 col1='somevalue' , col2=0 , col3 '01330021123003003%'; the problem primary key index set doesn't work where col1='somevalue' , col2=0 , col3 '01330021123003003%' . seems can't utilize like operator and operator @ same time if want utilize created index. are there special indices can create create select faster? it seems can't u...