Re: [HACKERS] A Better External Sort? - Mailing list pgsql-performance

From Gregory Maxwell
Subject Re: [HACKERS] A Better External Sort?
Date
Msg-id e692861c0510031719p10a59b3je47942077d27cbfe@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] A Better External Sort?  (Ron Peacetree <rjpeace@earthlink.net>)
List 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 by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: [HACKERS] A Better External Sort?
Next
From: "Jan Aerts"
Date:
Subject: Re: index on custom function; explain