On Fri, 2023-04-14 at 19:04 +0800, 黄宁 wrote:
> i want to use cursor with hold ,but when I declare a curosr , it takes a long
> time to save the result set to disk. can i save the query state in memory?
> and fetch forward the next result.
The complete result set has to be materialized. It only spills to disk if it
is large. That cannot be avoided.
Yours,
Laurenz Albe