Re: [PERFORM] A Better External Sort? - Mailing list pgsql-hackers

From Jeffrey W. Baker
Subject Re: [PERFORM] A Better External Sort?
Date
Msg-id 1128372151.28509.1.camel@toonses.gghcwest.com
Whole thread Raw
In response to Re: [PERFORM] A Better External Sort?  (Josh Berkus <josh@agliodbs.com>)
Responses Re: [PERFORM] A Better External Sort?  (Josh Berkus <josh@agliodbs.com>)
List pgsql-hackers
On Mon, 2005-10-03 at 13:34 -0700, Josh Berkus wrote:
> Michael,
>
> > >Realistically, you can't do better than about 25MB/s on a
> > > single-threaded I/O on current Linux machines,
> >
> > What on earth gives you that idea? Did you drop a zero?
>
> Nope, LOTS of testing, at OSDL, GreenPlum and Sun.   For comparison, A
> Big-Name Proprietary Database doesn't get much more than that either.

I find this claim very suspicious.  I get single-threaded reads in
excess of 1GB/sec with XFS and > 250MB/sec with ext3.

-jwb

pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: [PERFORM] A Better External Sort?
Next
From: Hannu Krosing
Date:
Subject: Re: effective SELECT from child tables