multicolumn indexes still efficient if not fully stressed? - Mailing list pgsql-performance

From Jörg Kiegeland
Subject multicolumn indexes still efficient if not fully stressed?
Date
Msg-id 496B82BC.5020504@ikv.de
Whole thread Raw
Responses Re: multicolumn indexes still efficient if not fullystressed?  ("Mark Lewis" <mark.lewis@mir3.com>)
Re: multicolumn indexes still efficient if not fully stressed?  (Andreas Kretschmer <akretschmer@spamfence.net>)
List pgsql-performance
Hello,

I created a multicolumn index on the columns c_1,..,c_n .
If I do use only a true subset of these columns in a SQL query, is the
index still efficient?
Or is it better to create another multicolumn index defined on this subset?

Thanks for any comments!

pgsql-performance by date:

Previous
From: Matthew Wakeling
Date:
Subject: Re: understanding postgres issues/bottlenecks
Next
From: "Mark Lewis"
Date:
Subject: Re: multicolumn indexes still efficient if not fullystressed?