cursor with hold must be save to disk?

From: 黄宁 <huangning0722(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: cursor with hold must be save to disk?
Date: 2023-04-14 11:04:16
Message-ID: CAKgrFs9Uq5FUMO6qQQDx0pPQyzkDqw-dGJc=VMupzuLbQ0b=jw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marc Millas 2023-04-14 14:26:11 SIze 0 in pg_stat_file, pg_stat_progress_copy
Previous Message Alban Hertroys 2023-04-14 08:42:26 Re: "PANIC: could not open critical system index 2662" - twice