Re: Index Skip Scan - Mailing list pgsql-hackers

From Floris Van Nee
Subject Re: Index Skip Scan
Date
Msg-id 1562770824851.93603@Optiver.com
Whole thread Raw
In response to Re: Index Skip Scan  (Floris Van Nee <florisvannee@Optiver.com>)
Responses Re: Index Skip Scan  (Dmitry Dolgov <9erthalion6@gmail.com>)
List pgsql-hackers
> Thanks for testing! Could you provide a test case to show what exactly is the
> problem?

Note that in the case of a regular non-skip scan, this cursor backwards works because the Unique node on top does not
supportbackwards scanning at all. Therefore, when creating the cursor, the actual plan actually contains a Materialize
nodeon top of the Unique+Index Scan nodes. The 'fetch backwards' never reaches the the index scan therefore, as it just
fetchesstuff from the materialize node. 

-Floris


pgsql-hackers by date:

Previous
From: Dmitry Dolgov
Date:
Subject: Re: Index Skip Scan
Next
From: Dmitry Dolgov
Date:
Subject: Re: Index Skip Scan