Hiroshi Inoue wrote:
> > 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.
>
> Other than the out of disk/memory problem, there 's
> another problem. What I expect of cursors is the
> constant response time while handling them.
Cursors outside transactions either need materialization or long-lived
locks --- I don't see any other possibilities, and most feel
materialization is the best.
Do you see another option?
-- 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