So,
what *exactly* did you try? And was the outcome exactly the same as before?
Best regards, Julian
Am 21.10.2020 um 15:20 schrieb Tanvi Shah:
Hi Julian,
Tried by adding 'defaultRowFetchSize' but it is still taking by default INT
value.
Thanks.
________________________________________
From: Julian Reschke <[email protected]>
Sent: 21 October 2020 16:45
To: Tanvi Shah; [email protected]
Subject: Re: Error in S3 Garbage Collection
[External - Use Caution]
Am 21.10.2020 um 12:41 schrieb Tanvi Shah:
Hi,
I couldn't find the option to set the limit for Query in S3
GC.(<https://urldefense.proofpoint.com/v2/url?u=https-3A__jdbc.postgresql.org_documentation_head_connect.html-23connection-2Dparameters&d=DwIFaQ&c=vh6FgFnduejNhPPD0fl_yRaSfZy8CWbWnIf4XJhSqx8&r=efxn8UeXcSHRO_QY23J3UMMNiX9eCS4lSzRWxErP-mo&m=2N5ynCyAkZxKcJP11i0_6FDBn8Kw93vA28vW0r9BBKk&s=CEhXZpXVRZp6VkG8bD6ErEfknIhyE59yHp8STPA2huM&e=
<https://urldefense.proofpoint.com/v2/url?u=https-3A__jdbc.postgresql.org_documentation_head_connect.html-23connection-2Dparameters&d=DwIFaQ&c=vh6FgFnduejNhPPD0fl_yRaSfZy8CWbWnIf4XJhSqx8&r=efxn8UeXcSHRO_QY23J3UMMNiX9eCS4lSzRWxErP-mo&m=2N5ynCyAkZxKcJP11i0_6FDBn8Kw93vA28vW0r9BBKk&s=CEhXZpXVRZp6VkG8bD6ErEfknIhyE59yHp8STPA2huM&e=
>>).
...
Citing above:
defaultRowFetchSize = int
Determine the number of rows fetched in ResultSet by one fetch with trip to the
database. Limiting the number of rows are fetch with each trip to the database
allow avoids unnecessary memory consumption and as a consequence
OutOfMemoryException.
The default is zero, meaning that in ResultSet will be fetch all rows at once.
Negative number is not available.
So something like
jdbc:postgresql://host:port/database?defaultRowFetchSize=1000
might do it.
Best regards, Julian
**********************************************************************
Disclaimer: This e-mail is confidential and should not be used by anyone who is
not the original intended recipient. If you have received this e-mail in error
please inform the sender and delete it from your mailbox or any other storage
mechanism. Springer Nature Technology and Publishing Solutions Private Limited
does not accept liability for any statements made which are clearly the
sender's own and not expressly made on behalf of Springer Nature Technology and
Publishing Solutions Private Limited or one of their agents.
Please note that Springer Nature Technology and Publishing Solutions Private
Limited and their agents and affiliates do not accept any responsibility for
viruses or malware that may be contained in this e-mail or its attachments and
it is your responsibility to scan the e-mail and attachments (if any).
Springer Nature Technology and Publishing Solutions Private Limited. Registered
office: Upper Ground Floor, Wing B, Tower 8, Magarpatta City SEZ, Hadapsar Pune
MH 411013 IN
Registered number: U72200PN2006FTC128967
