Postgres Pro
Downloads
Home   >   mailing lists

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

From Josh Berkus
Subject Re: [PERFORM] A Better External Sort?
Date
Msg-id 200510031334.02030.josh@agliodbs.com
Whole thread Raw
In response to Re: [PERFORM] A Better External Sort?  (Michael Stone <mstone+postgres@mathom.us>)
Responses Re: [PERFORM] A Better External Sort?  ("Jeffrey W. Baker" <jwbaker@acm.org>)
Re: [PERFORM] A Better External Sort?  (Michael Stone <mstone+postgres@mathom.us>)
List pgsql-hackers
Tree view 
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.

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

pgsql-hackers by date:

Previous
From: Jeff Davis
Date:
Subject: Re: PG Killed by OOM Condition
Next
From: Simon Riggs
Date:
Subject: Re: External Sort timing debug statements