Josh Berkus <josh(at)agliodbs(dot)com> wrote:
> On 10/24/11 12:35 PM, Tom Lane wrote:
>> Your point about people trying to create wider indexes to exploit
>> index-only scans is an interesting one, but I think it's
>> premature to optimize on the basis of hypotheses about what
>> people might do in future.
>
> I don't think that this is hypothetical at all. I know *I'll* be
> doing it, and we can expect users who are familiar with MySQL and
> Oracle to do it as well.
And Sybase, and MS SQL Server. And others, most likely. We've
never gotten around to narrowing the indexes to which we added extra
columns to overcome performance problems through "covering index"
techniques when we were using Sybase, so they're already here. :-)
> One case which is going to be critical to test is the "join"
> table, i.e. the table which supports many-to-many joins and
> consists only of keys from the respective two other tables.
Yeah, that is an important use of covering indexes for us.
-Kevin