Re: Index on multiple columns VS multiple index

this was what I was guessing. Thank you for the confirmation.

So I think that I now have a clear idea on the best index strategy for my
project.

Thanks for your help,

Regard,
Brice

2014/1/2 Jonathan S. Katz <jonathan(dot)katz(at)excoventures(dot)com>

> On Jan 2, 2014, at 3:00 PM, Brice André wrote:
>
> > 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
>
>