Re: [HACKERS] A Better External Sort?

Поиск
Список
Период
Сортировка
От Gregory Maxwell
Тема Re: [HACKERS] A Better External Sort?
Дата
Msg-id e692861c0510031719p10a59b3je47942077d27cbfe@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] A Better External Sort?  (Ron Peacetree <rjpeace@earthlink.net>)
Список pgsql-performance
On 10/3/05, Ron Peacetree <rjpeace@earthlink.net> wrote:
[snip]
> Just how bad is this CPU bound condition?  How powerful a CPU is
> needed to attain a DB IO rate of 25MBps?
>
> If we replace said CPU with one 2x, 10x, etc faster than that, do we
> see any performance increase?
>
> If a modest CPU can drive a DB IO rate of 25MBps, but that rate
> does not go up regardless of how much extra CPU we throw at
> it...

Single threaded was mentioned.
Plus even if it's purely cpu bound, it's seldom as trivial as throwing
CPU at it, consider the locking in both the application, in the
filesystem, and elsewhere in the kernel.

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

Предыдущее
От: Hannu Krosing
Дата:
Сообщение: Re: [HACKERS] A Better External Sort?
Следующее
От: "Jan Aerts"
Дата:
Сообщение: Re: index on custom function; explain