> On Wed, Jul 10, 2019 at 5:00 PM Floris Van Nee <florisvan...@optiver.com> > wrote: > > > > 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 support backwards scanning at all. > Therefore, when creating the cursor, the actual plan actually contains a > Materialize node on top of the Unique+Index Scan nodes. The 'fetch backwards' > never reaches the the index scan therefore, as it just fetches stuff from the > materialize node.
Yeah, I'm aware. The last time when I was busy with cursors I've managed to make it work as I wanted, so at that time I decided to keep it like that, even though without skip scan it wasn't doing backwards.