When BI tool connects to pg, it causes OOM

[baitao061250]

I can only add the defaultRowFetchSize parameter in the URL, but I cannot set to turn off automatic submission. Now I am struggling to connect to PG for tableau

[davecramer]

So by automatic submission you mean autocommit mode

[baitao061250]

Yes, I am thinking that if there is no solution, I can try to compile my own jar, but I don't know where to modify it appropriately, which means it will have the least impact.

[baitao061250]

My connection tool is Tableau Server, mainly used for refreshing and extracting data.

[davecramer]

pgjdbc/pgjdbc/src/main/java/org/postgresql/jdbc/PgConnection.java

Line 937 in 4e710d5

public void setAutoCommit(boolean autoCommit) throws SQLException {