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
Дата:
От: Gregory Stark
Дата:
FAQ