Re: Out of memory error on huge resultset

Nic Ferrier <nferrier@tapsellferrier.co.uk>

From: nferrier@tapsellferrier.co.uk
To: Dave Cramer <Dave@micro-automation.net>
Cc: Aaron Mulder <ammulder@alumni.princeton.edu>, pgsql-jdbc <pgsql-jdbc@postgresql.org>
Date: 2002-10-11T14:52:18Z
Lists: pgsql-hackers, pgsql-general
Dave Cramer <Dave@micro-automation.net> writes:

> No disadvantage, in fact that is what we would like to do.
> 
> 
> setFetchSize(size)  turns on cursor support, otherwise fetch
> normally

I love PostgreSQL's default behaviour: it's great to know
that a server side cursor resource is probably not hanging around for
simple querys.



Nic