Postgres Pro
Downloads
Home   >   mailing lists

Re: Not overflow RAM with default fetchSize? - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: Not overflow RAM with default fetchSize?
Date
Msg-id CADK3HHKY_Uoc=_r=QMCg-MowuF1sinR=HJ_NMCVEdgqyoGnTsA@mail.gmail.com
Whole thread Raw
In response to Not overflow RAM with default fetchSize?  (Roger Pack <rogerdpack2@gmail.com>)
List pgsql-jdbc
Tree view
Please post an issue on github for this.

Issues · pgjdbc/pgjdbc (github.com)
Dave Cramer
www.postgres.rocks


On Fri, 22 Apr 2022 at 13:45, Roger Pack <rogerdpack2@gmail.com> wrote:
Might be nice to have the default fetch size be a "reasonably
performant" number, with the default (unlimited), it can overflow
memory for large queries which is confusing.  Or at least it used to,
I haven't tested it in awhile.
Cheers!
-=roger=


pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: Why does the prepareThreshold=0 (to cover pgbouncer transaction mode) disables protocol binary transfers ? (w/ PoC patch and measurements)
Next
From: Dave Cramer
Date:
Subject: Re: BUG #17467: Perf degradation after switching to latest jdbc drivers