[btown]

I would love to be able to SET multiple_planning; on a cursor to be able to say “yes I know that reversing would be UB, and I have set a limit so I don’t care if results aren’t streamed, so please just try everything you can.” In general I wish there were better ways to tell these systems you know what you’re doing.

[cormacrelf]

There could also be a “clean the slate” streaming directive, which means “I started the query again, please scratch what got delivered already”.

[JelteF]

That effictively means the client cannot actually start processing the results before everything is received. Because you would have to undo everything you did with the data you received before. So basically this would simply be a non streaming version.

[Bootvis]

I believe the best you can do is to delay streaming. Now you have the problem of deciding when to start...