From: | Dave Cramer <davecramer(at)gmail(dot)com> |
---|---|
To: | Jaime Soler <jaime(dot)soler(at)gmail(dot)com> |
Cc: | aistrong(dot)hs(at)gmail(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org |
Subject: | Re: BUG #15152: Java heap size |
Date: | 2018-04-23 22:25:07 |
Message-ID: | CADK3HHK+cZABDhgzE-P7FeHcmkzvh+YjA1w27u4qjKDza_-D9Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
But to answer your question the reason we need autocommit off is because
PostgreSQL would have to use a WITH HOLD cursor outside of a transaction.
WITH HOLD cursors materialize cursors to disk. There is no technical reason
we don't support them. If you are interested you can supply a PR for us.
Thanks
Dave Cramer
On 13 April 2018 at 03:27, Jaime Soler <jaime(dot)soler(at)gmail(dot)com> wrote:
> Hi,
> If you have any question related to jdbc driver you should send it to
> pgsql-jdbc(at)postgresql(dot)org . Also I would like to mention that you could
> use defaultRowFetchSize = int at connection level or setFetchSize at
> statement level to define how many record will be read by resultset .
>
> Regards
>
>
> 2018-04-13 8:50 GMT+02:00 PG Bug reporting form <noreply(at)postgresql(dot)org>:
>
>> The following bug has been logged on the website:
>>
>> Bug reference: 15152
>> Logged by: Isaac Arasavalli
>> Email address: aistrong(dot)hs(at)gmail(dot)com
>> PostgreSQL version: 10.1
>> Operating system: Windows 7
>> Description:
>>
>> When I fetch a table with huge data, the result set fails with heap issue
>> with postgreSql.
>> But in DB2 it fetches group by group so it handles.
>> To fix there is an option to set autocommit off and set fetch size at
>> resultset.
>>
>> For, this I have to do lot of code change due to many occurrences of
>> simila
>> issue in my huge application.
>>
>> Is there any alternative to fix this, like setting any parameters at data
>> source leve or any other way to minimize code change and solve.
>>
>> Please help.
>>
>>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Cramer | 2018-04-23 22:25:50 | Re: BUG #15158: JDBC driver has faulty comparison in method: haveMinimumServerVersion(String ver) |
Previous Message | Hao Lee | 2018-04-23 08:28:16 | Re: BUG #15167: error C2365: 'errcode' : redefi nition; previous definition |