Re: Sorting Improvements for 8.4
От | Andreas Joseph Krogh |
---|---|
Тема | Re: Sorting Improvements for 8.4 |
Дата | |
Msg-id | 200712191302.17093.andreak@officenet.no обсуждение исходный текст |
Ответ на | Re: Sorting Improvements for 8.4 (Dimitri Fontaine <dfontaine@hi-media.com>) |
Ответы |
Re: Sorting Improvements for 8.4
|
Список | pgsql-hackers |
On Tuesday 18 December 2007 10:03:25 Dimitri Fontaine wrote: > Hi, > > Le mardi 18 décembre 2007, Ron Mayer a écrit : > > Has anyone looked into sorting algorithms that could use > > more than one CPU or core at a time? > > [...] > > > PS: Yeah, I know multi-threading is a hot-button on these > > lists; but sorting seems a relatively isolated of the code > > and I'd wonder if it'd be isolate-able enough that multiple > > CPUs could be used there. > > And before that objection to multi-threading implementation and portability > concerns arise, what about using a coroutine BSD-licenced portable > implementation such as Protothreads to have backend code use several CPU at > a time? > http://www.sics.se/~adam/pt/ > > With such a tool, would it be possible to think about producer/consumer > parallel executions for sorting, aggregates nodes or other parts of the > executor? > > Hope this helps, regards, And remember; Users don't care about portability-issues, they care about performance. If multi-threading is a way to speed up sorting considerably, it should, IMHO, be considered seriously. -- Andreas Joseph Krogh
В списке pgsql-hackers по дате отправления: