Re: Unused index influencing sequential scan plan - Mailing list pgsql-performance

From Thom Brown
Subject Re: Unused index influencing sequential scan plan
Date
Msg-id CAA-aLv68tNQt0-CR2b3wxqu+D0FUDz+bTVPnE6gE6riKCbXERw@mail.gmail.com
Whole thread Raw
In response to Re: Unused index influencing sequential scan plan  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Unused index influencing sequential scan plan  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-performance
On 18 October 2012 17:44, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Thom Brown <thom@linux.com> writes:
>> And as a side note, how come it's impossible to get the planner to use
>> an index-only scan to satisfy the query (disabling sequential and
>> regular index scans)?
>
> Implementation restriction - we don't yet have a way to match index-only
> scans to expressions.

Ah, I suspected it might be, but couldn't find notes on what scenarios
it's yet to be able to work in.  Thanks.

--
Thom


pgsql-performance by date:

Previous
From: Thom Brown
Date:
Subject: Re: Unused index influencing sequential scan plan
Next
From: Tom Lane
Date:
Subject: Re: Unused index influencing sequential scan plan