Re: scrollable cursor support without MOVE statement
От | Pavel Stehule |
---|---|
Тема | Re: scrollable cursor support without MOVE statement |
Дата | |
Msg-id | BAY114-F15A6EC6A2AADC37EDF3E25F9500@phx.gbl обсуждение исходный текст |
Ответ на | Re: scrollable cursor support without MOVE statement ("Simon Riggs" <simon@2ndquadrant.com>) |
Список | pgsql-patches |
>On Wed, 2007-03-28 at 17:42 +0200, Pavel Stehule wrote: > > > > > >This is the most recent email I have on this. Was the scrollable patch > > >applied? If not, would you resubmit? > > > > > > > I resubmit scrollable cursor patch > >I notice your patch has been accepted, though admit I hadn't noticed it >previously. I resubmited this patch because Bruce removed it from queue instead of GUC protection patch > >Can I ask a question relating to the patch? >How is the scrollability determined? > >Scrollable cursors and sorts don't mix very well in terms of >performance, as you may know. Previously, since NOSCROLL was the only >option, this wasn't a problem. Now that we have scrollable cursors, it >is an issue, since according to the doc change the scrollability default >is neither scroll nor noscroll. default is noscroll > >I'm concerned that many PL/pgSQL routines will now run slower because >they may now be considered scrollable when they previously were not. How >is the scrollability determined? Do we look at the kids of FETCH being >used to determine whether we need scrolling? (which would be great) Or >will we have to manually change all existing PL/pgSQL code so that it is >definitely NOSCROLL? (which would be unacceptable). Or? > default is without changes on functionality. Regards Pavel Stehule _________________________________________________________________ Emotikony a pozadi programu MSN Messenger ozivi vasi konverzaci. http://messenger.msn.cz/
В списке pgsql-patches по дате отправления: