Re: Scrollable cursors and Sort performance
От | Simon Riggs |
---|---|
Тема | Re: Scrollable cursors and Sort performance |
Дата | |
Msg-id | 1141062288.27729.32.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | Re: Scrollable cursors and Sort performance (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-hackers |
On Mon, 2006-02-27 at 10:07 -0500, Tom Lane wrote: > Simon Riggs <simon@2ndquadrant.com> writes: > > On Sun, 2006-02-26 at 19:26 -0500, Tom Lane wrote: > >> After looking at my old notes about Materialize, > >> I am thinking that we should add a "int flags" parameter to the InitNode > >> calls along with ExecutorStart and probably PortalStart. > > > Design-wise I was looking at putting a named struc in there, so it would > > be easily expandible in the future to carry anything else that needs to > > be passed down through the nodes like this. > > That would be the hard way, primarily because it would require copying > and modifying the struct at each level of recursion --- which'd turn > what should be a nearly zero-cost patch into something with possibly > nontrivial cost. Yeh, didn't take me long to see the costs; I just gave that idea up prior to reading your post. I won't go into *why* I was trying that, especially since I've stopped... Following your recipe pretty close as of now. Best Regards, Simon Riggs
В списке pgsql-hackers по дате отправления: