@charles or anyone, I have a specific question around

JdbcStreamingQueryConfiguration

. I see that all the implementations of the interface are doing this

@Override
  public void accept(Connection connection, PreparedStatement preparedStatement) throws SQLException {
    connection.setAutoCommit(false);
    preparedStatement.setFetchSize(1000);
  }

My question is why do we need to set the

AutoCommit

as false if we are just using a SELECT query to fetch the data?

woof. this is a while ago.

i don't remember off the top of my head why automcommit needs to be set to false.

i just remember reading that it needed to be the case.

sorry. that's not that helpful.

you can try to run a stress test e.g.

PostgresStressTest

with the line removed and see what happens.