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. 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. 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? -- Simon Riggs EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend