Hi Julian, Tried by adding 'defaultRowFetchSize' but it is still taking by default INT value.
Thanks. ________________________________________ From: Julian Reschke <julian.resc...@gmx.de> Sent: 21 October 2020 16:45 To: Tanvi Shah; oak-dev@jackrabbit.apache.org 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