Re: cursors outside transactions - Mailing list pgsql-hackers

From Hiroshi Inoue
Subject Re: cursors outside transactions
Date
Msg-id 3E7931A1.6124DAD6@tpf.co.jp
Whole thread Raw
In response to Re: cursors outside transactions  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: cursors outside transactions  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
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 ?

regards,
Hiroshi Inouehttp://www.geocities.jp/inocchichichi/psqlodbc/


pgsql-hackers by date:

Previous
From: Neil Conway
Date:
Subject: Re: string || NULL ambiguity
Next
From: Bruce Momjian
Date:
Subject: Re: cursors outside transactions