Re: cursor with hold must be save to disk? - Mailing list pgsql-general

From Laurenz Albe
Subject Re: cursor with hold must be save to disk?
Date
Msg-id 2c62dd64316c1cf8b49bb4298603a73488e5d7be.camel@cybertec.at
Whole thread Raw
In response to cursor with hold must be save to disk?  (黄宁 <huangning0722@gmail.com>)
List pgsql-general
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



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: cursor with hold must be save to disk?
Next
From: GF
Date:
Subject: Re: [Extern] Re: Is a logical replication crash recovery safe?