Re: CUDA Sorting

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: CUDA Sorting
Дата
Msg-id
17298.1316445378@sss.pgh.pa.us
Ответ на
Re: CUDA Sorting (Greg Stark)
Список
Дерево обсуждения
CUDA Sorting Vitor Reus <vitor.reus@gmail.com>
Re: CUDA Sorting Thom Brown <thom@linux.com>
Re: CUDA Sorting Nulik Nol <nuliknol@gmail.com>
Re: CUDA Sorting Vitor Reus <vitor.reus@gmail.com>
Re: CUDA Sorting Nulik Nol <nuliknol@gmail.com>
Re: CUDA Sorting Greg Stark <stark@mit.edu>
Re: CUDA Sorting Hannu Krosing <hannu@2ndQuadrant.com>
Re: CUDA Sorting Greg Smith <greg@2ndQuadrant.com>
Re: CUDA Sorting Hannu Krosing <hannu@krosing.net>
Re: CUDA Sorting Vitor Reus <vitor.reus@gmail.com>
Re: CUDA Sorting Gaetano Mendola <mendola@gmail.com>
Re: CUDA Sorting Greg Smith <greg@2ndQuadrant.com>
Re: CUDA Sorting Gaetano Mendola <mendola@gmail.com>
Re: CUDA Sorting Kohei KaiGai <kaigai@kaigai.gr.jp>
Re: CUDA Sorting Gaetano Mendola <mendola@gmail.com>
Re: CUDA Sorting Greg Stark <stark@mit.edu>
Re: CUDA Sorting Gaetano Mendola <mendola@gmail.com>
Re: CUDA Sorting Peter Geoghegan <peter@2ndquadrant.com>
Re: CUDA Sorting Gaetano Mendola <mendola@gmail.com>
Re: CUDA Sorting Dann Corbit <DCorbit@connx.com>
Re: CUDA Sorting Peter Geoghegan <peter@2ndquadrant.com>
Re: CUDA Sorting Gaetano Mendola <mendola@gmail.com>
Re: CUDA Sorting Gaetano Mendola <mendola@gmail.com>
Re: CUDA Sorting Marti Raudsepp <marti@juffo.org>
Re: CUDA Sorting Gaetano Mendola <mendola@gmail.com>
Re: CUDA Sorting Oleg Bartunov <oleg@sai.msu.su>
Re: CUDA Sorting Gaetano Mendola <mendola@gmail.com>
Re: CUDA Sorting Thom Brown <thom@linux.com>
Re: CUDA Sorting Stephen Frost <sfrost@snowman.net>
Re: CUDA Sorting Florian Pflug <fgp@phlo.org>
Re: CUDA Sorting Greg Smith <greg@2ndQuadrant.com>
Re: CUDA Sorting Cédric Villemain <cedric.villemain.debian@gmail.com>
Re: CUDA Sorting Christopher Browne <cbbrowne@gmail.com>
Re: CUDA Sorting Greg Stark <stark@mit.edu>
Re: CUDA Sorting Tom Lane <tgl@sss.pgh.pa.us>
Re: CUDA Sorting PostgreSQL - Hans-Jürgen Schönig<postgres@cybertec.at>
Re: CUDA Sorting Gaetano Mendola <mendola@gmail.com>
Re: CUDA Sorting Vitor Reus <vitor.reus@gmail.com>
Re: CUDA Sorting Thom Brown <thom@linux.com>
Re: CUDA Sorting Thom Brown <thom@linux.com>
Greg Stark  writes:
> That said, to help in the case I described you would have to implement
> the tapesort algorithm on the GPU as well.

I think the real problem would be that we are seldom sorting just the
key values.  If you have to push the tuples through the GPU too, your
savings are going to go up in smoke pretty quickly ...

FWIW, I tend to believe a variant of what Greg Stark said upthread:
there would surely be some win from reducing the impedance mismatch for
comparison functions.  In concrete terms, there would be no reason to
have tuplesort.c's myFunctionCall2Coll, and maybe not
inlineApplySortFunction either, if the datatype-specific comparison
functions had APIs that were closer to what sorting wants rather than
following the general SQL-callable-function API.  And those functions
cost a *lot* more than a one-instruction comparison does.  But it's very
much more of a stretch to believe that inlining per se is going to do
much for us, and even more of a stretch to believe that getting a
separate processor involved is going to be a win.
		regards, tom lane

В списке pgsql-hackers по дате отправления
От: Tom Lane
Дата:
От: Enrico Pirozzi
Дата:
Сообщение: Re: A little pg_dump patch
FAQ