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
