Re: ResultSet storing all rows with defaulftFetchSize to 5000

Поиск
Список
Период
Сортировка
От Vladimir Sitnikov
Тема Re: ResultSet storing all rows with defaulftFetchSize to 5000
Дата
Msg-id CAB=Je-HnaV1cEHZfdtTrV=QjYc-F47rbhsOo5PQowPao4DiXxQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: ResultSet storing all rows with defaulftFetchSize to 5000  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: ResultSet storing all rows with defaulftFetchSize to 5000
Список pgsql-jdbc
Дерево обсуждения
Tom>It's available through DECLARE CURSOR WITH HOLD.

docs>In the current implementation, the rows represented by a held cursor are copied into a temporary file or memory area so that they remain available for subsequent transactions.

The backend materializes, so it is a sad thing.
Is there a change "with hold" can be implemented without materialization?
I just wonder if it is more like "not yet implemented" or if it would take incredible amount of resources to implement.

Vladimir

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: ResultSet storing all rows with defaulftFetchSize to 5000
Следующее
От: Tom Lane
Дата:
Сообщение: Re: ResultSet storing all rows with defaulftFetchSize to 5000