> But I have still one question that remains : > > suppose I define an index on ('a', 'b') columns, will it be useful for a search on 'a' column only, or will it be ignore by postgresl ?
If you define the index on ('a', 'b') in that order and are just searching for 'a' in your query, the query planner will use the index. Jonathan