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://jdbc.postgresql.org/documentation/head/connect.html#connection-parameters
<https://jdbc.postgresql.org/documentation/head/connect.html#connection-parameters>>).
...
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
