Re: [HACKERS] A Better External Sort?

From: "Jeffrey W(dot) Baker" <jwbaker(at)acm(dot)org>
To: Ron Peacetree <rjpeace(at)earthlink(dot)net>
Cc: Luke Lonergan <LLonergan(at)greenplum(dot)com>, pgsql-hackers(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org
Subject: Re: [HACKERS] A Better External Sort?
Date: 2005-10-05 18:30:21
Message-ID: 1128537021.3963.1.camel@toonses.gghcwest.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-performance

On Wed, 2005-10-05 at 12:14 -0400, Ron Peacetree wrote:
> I've now gotten verification from multiple working DBA's that DB2, Oracle, and
> SQL Server can achieve ~250MBps ASTR (with as much as ~500MBps ASTR in
> setups akin to Oracle RAC) when attached to a decent (not outrageous, but
> decent) HD subsystem...
>
> I've not yet had any RW DBA verify Jeff Baker's supposition that ~1GBps ASTR is
> attainable. Cache based bursts that high, yes. ASTR, no.

I find your tone annoying. That you do not have access to this level of
hardware proves nothing, other than pointing out that your repeated
emails on this list are based on supposition.

If you want 1GB/sec STR you need:

1) 1 or more Itanium CPUs
2) 24 or more disks
3) 2 or more SATA controllers
4) Linux

Have fun.

-jwb

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2005-10-05 18:30:47 Re: Fwd: 8.1beta2 vacuum analyze hanging on idle database
Previous Message Tom Lane 2005-10-05 18:27:32 Re: Fwd: 8.1beta2 vacuum analyze hanging on idle database

Browse pgsql-performance by date

  From Date Subject
Next Message Steinar H. Gunderson 2005-10-05 18:34:41 Re: Text/Varchar performance...
Previous Message Cristian Prieto 2005-10-05 18:21:35 Text/Varchar performance...