Tom Lane wrote:
> Dave Cramer <Dave@micro-automation.net> writes:
> > On Tue, 2003-03-18 at 19:00, Hiroshi Inoue wrote:
> >> ODBC(maybe JDBC also) has cross-transaction result sets
> >> (rather than cursors) since long by simply holding all
> >> results for a query at client side.
>
> > JDBC is running into problems with this. Large queries cause out of
> > memory exceptions.
>
> Cursors implemented as Neil suggests would cause out-of-disk exceptions.
> The limit is presumably further away than out-of-memory, but not any the
> less real. I'm concerned about this because, in my mind, one of the
> principal uses of cursors is to deal with too-huge-to-materialize result
> sets.
I don't see how you can class out of memory in the same likelyhood as
out of disk --- sure they are both real possible failures, but clearly
the latter is more rare and giving folks backing store for large result
sets is a big win in my book.
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square,
Pennsylvania19073