Re: WIP patch: convert SQL-language functions to return tuplestores
От
Simon Riggs
Тема
Re: WIP patch: convert SQL-language functions to return
tuplestores
Дата
Msg-id
1225191009.3971.130.camel@ebony.2ndQuadrant
Ответ на
Список
Дерево обсуждения
WIP patch: convert SQL-language functions to return tuplestores Tom Lane <tgl@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 Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP patch: convert SQL-language functions to return
tuplestores Kenneth Marshall <ktm@rice.edu>
Optimizing tuplestore usage for SRFs Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP patch: convert SQL-language functions to return tuplestores Martijn van Oosterhout <kleptog@svana.org>
Re: WIP patch: convert SQL-language functions to return tuplestores Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP patch: convert SQL-language functions to return tuplestores "Robert Haas" <robertmhaas@gmail.com>
Re: WIP patch: convert SQL-language functions to return tuplestores Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP patch: convert SQL-language functions to return tuplestores Gregory Stark <stark@enterprisedb.com>
Re: WIP patch: convert SQL-language functions to return tuplestores Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP patch: convert SQL-language functions to return tuplestores Dimitri Fontaine <dfontaine@hi-media.com>
Re: WIP patch: convert SQL-language functions to return tuplestores "Pavel Stehule" <pavel.stehule@gmail.com>
Re: WIP patch: convert SQL-language functions to return tuplestores Dimitri Fontaine <dfontaine@hi-media.com>
Re: WIP patch: convert SQL-language functions to return tuplestores Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP patch: convert SQL-language functions to return tuplestores Dimitri Fontaine <dfontaine@hi-media.com>
Re: WIP patch: convert SQL-language functions to return tuplestores Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP patch: convert SQL-language functions to return tuplestores Dimitri Fontaine <dfontaine@hi-media.com>
Re: WIP patch: convert SQL-language functions to return tuplestores Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP patch: convert SQL-language functions to return
tuplestores Hannu Krosing <hannu@2ndQuadrant.com>
Re: WIP patch: convert SQL-language functions to return tuplestores Dimitri Fontaine <dfontaine@hi-media.com>
Re: WIP patch: convert SQL-language functions to return tuplestores Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP patch: convert SQL-language functions to return tuplestores Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP patch: convert SQL-language functions to return tuplestores Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP patch: convert SQL-language functions to return tuplestores Dimitri Fontaine <dfontaine@hi-media.com>
Re: WIP patch: convert SQL-language functions to return tuplestores "Robert Haas" <robertmhaas@gmail.com>
Re: WIP patch: convert SQL-language functions to return tuplestores "Pavel Stehule" <pavel.stehule@gmail.com>
Re: WIP patch: convert SQL-language functions to return tuplestores "Robert Haas" <robertmhaas@gmail.com>
Re: WIP patch: convert SQL-language functions to return tuplestores "Pavel Stehule" <pavel.stehule@gmail.com>
Re: WIP patch: convert SQL-language functions to return tuplestores Tom Lane <tgl@sss.pgh.pa.us>
Re: WIP patch: convert SQL-language functions to return tuplestores "Pavel Stehule" <pavel.stehule@gmail.com>
Re: WIP patch: convert SQL-language functions to return tuplestores "Robert Haas" <robertmhaas@gmail.com>
Re: WIP patch: convert SQL-language functions to return tuplestores "Robert Haas" <robertmhaas@gmail.com>
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. -- Simon Riggs www.2ndQuadrant.comPostgreSQL Training, Services and Support
В списке pgsql-hackers по дате отправления
От: Gregory Stark
Дата: