Re: Sorting Improvements for 8.4

Поиск
Список
Период
Сортировка
От Dimitri Fontaine
Тема Re: Sorting Improvements for 8.4
Дата
Msg-id 200712181003.27337.dfontaine@hi-media.com
обсуждение исходный текст
Ответ на Re: Sorting Improvements for 8.4  (Ron Mayer <rm_pg@cheapcomplexdevices.com>)
Ответы Re: Sorting Improvements for 8.4  (Andreas Joseph Krogh <andreak@officenet.no>)
Список pgsql-hackers
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,
--
dim

В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Trevor Talbot"
Дата:
Сообщение: Re: EXPLAIN ANALYZE printing logical and hardware I/O per-node
Следующее
От: Oleg Bartunov
Дата:
Сообщение: Re: Board for developers