Re: cursors outside transactions

Hiroshi Inoue wrote:
> Bruce Momjian wrote:
> > 
> > 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 
> 
> 
> AccessShare table locks are only needed.
> What is wrong with it ?

But that is going to block VACUUM, right?  Aren't we better
materializing and letting vacuum run?  I am not sure --- I am just
asking.

--  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