Re: Index Skip Scan

Hi,

On 6/5/19 3:39 PM, Floris Van Nee wrote:
> Thanks! I've verified that it works now.

Here is a rebased version.

> I was wondering if we're not too strict in some cases now though. Consider the following queries:

[snip]

> This is basically the opposite case - when distinct_pathkeys matches the filtered list of index keys, an index skip
scancould be considered. Currently, the user needs to write 'distinct m,f' explicitly, even though he specifies in the
WHERE-clausethat 'm' can only have one value anyway. Perhaps it's fine like this, but it could be a small improvement
forconsistency.
 
> 

I think it would be good to get more feedback on the patch in general 
before looking at further optimizations. We should of course fix any 
bugs that shows up.

Thanks for your testing and feedback !

Best regards,
  Jesper