Re: cursors outside transactions

Поиск
Список
Период
Сортировка
От Hiroshi Inoue
Тема Re: cursors outside transactions
Дата
Msg-id 3E7931A1.6124DAD6@tpf.co.jp
обсуждение исходный текст
Ответ на Re: cursors outside transactions  (Bruce Momjian <pgman@candle.pha.pa.us>)
Ответы Re: cursors outside transactions
Список 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 по дате отправления:

Предыдущее
От: Neil Conway
Дата:
Сообщение: Re: string || NULL ambiguity
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: cursors outside transactions