multicolumn indexes still efficient if not fully stressed?

From: Jörg Kiegeland <kiegeland(at)ikv(dot)de>
To: pgsql-performance(at)postgresql(dot)org
Subject: multicolumn indexes still efficient if not fully stressed?
Date: 2009-01-12 17:49:48
Message-ID: 496B82BC.5020504@ikv.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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!

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Mark Lewis 2009-01-12 18:48:25 Re: multicolumn indexes still efficient if not fullystressed?
Previous Message Matthew Wakeling 2009-01-12 15:36:56 Re: understanding postgres issues/bottlenecks