Message-ID: <gh-pgjdbc-pgjdbc-2918@github.com>
From: "vlsi (@vlsi)" <noreply+vlsi@github.com>
To: "pgjdbc/pgjdbc" <noreply+pgjdbc-pgjdbc@github.com>
Date: Fri, 02 Jun 2023 15:29:31 +0000
Subject: [pgjdbc/pgjdbc] issue #2918: Set defaultRowFetchSize=10000 by default to improve app stability
List-Id: <gh-pgjdbc-pgjdbc.github.com>
X-GitHub-Assignees: davecramer
X-GitHub-Author-Id: 213894
X-GitHub-Author-Login: vlsi
X-GitHub-Issue: 2918
X-GitHub-Repo: pgjdbc/pgjdbc
X-GitHub-State: open
X-GitHub-Type: issue
X-GitHub-Url: https://github.com/pgjdbc/pgjdbc/issues/2918
Content-Type: text/plain; charset=utf-8

**Describe the issue**

Currently `defaultRowFetchSize` is `0`, so it fetches all the rows in-memory which might cause `OutOfMemoryConditions`
I suggest using a finite default to reduce the number of application failures.

We should align the change with adaptive fetch.