Postgres Pro
Downloads
Home   >   mailing lists

Thread: Not overflow RAM with default fetchSize?

Not overflow RAM with default fetchSize?

From
Roger Pack
Date:
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=

Re: Not overflow RAM with default fetchSize?

From
Dave Cramer
Date:
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=