Re: WIP patch: convert SQL-language functions to return tuplestores
От | Tom Lane |
---|---|
Тема | Re: WIP patch: convert SQL-language functions to return tuplestores |
Дата | |
Msg-id | 19221.1225200518@sss.pgh.pa.us обсуждение исходный текст |
Ответ на | Re: WIP patch: convert SQL-language functions to return tuplestores (Simon Riggs <simon@2ndQuadrant.com>) |
Ответы |
Re: WIP patch: convert SQL-language functions to return
tuplestores
Optimizing tuplestore usage for SRFs |
Список | pgsql-hackers |
Simon Riggs <simon@2ndQuadrant.com> writes: > On Sun, 2008-10-26 at 21:49 -0400, Tom Lane wrote: >> So I'm concluding that we can easily afford to switch to >> tuplestore-always operation, especially if we are willing to put any >> effort into tuplestore optimization. (I note that the current >> tuplestore code writes 24 bytes per row for this example, which is a >> shade on the high side for only 4 bytes payload. It looks like it >> would be pretty easy to knock 10 bytes off that for a 40% savings in >> I/O volume.) > That seems like an important, possibly more important, change. Yeah, seeing that both WITH and window functions will be stressing tuplestore performance, anything we can save there is probably worth the trouble. regards, tom lane
В списке pgsql-hackers по дате отправления: