Re: [HACKERS] A Better External Sort?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Cc: Michael Stone <mstone+postgres(at)mathom(dot)us>, pgsql-performance(at)postgresql(dot)org
Subject: Re: [HACKERS] A Better External Sort?
Date: 2005-10-03 20:34:01
Message-ID: 200510031334.02030.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2005-10-03 20:35:30 Tuning current tuplesort external sort code for 8.2
Previous Message Hannu Krosing 2005-10-03 20:32:26 Re: effective SELECT from child tables

Browse pgsql-performance by date

  From Date Subject
Next Message Josh Berkus 2005-10-03 20:40:29 Re: [HACKERS] A Better External Sort?
Previous Message Vivek Khera 2005-10-03 19:06:15 Re: Ultra-cheap NVRAM device