Re: Performance large tables. - Mailing list pgsql-general

From Greg Stark
Subject Re: Performance large tables.
Date
Msg-id 87slswervi.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: Performance large tables.  (Vivek Khera <vivek@khera.org>)
List pgsql-general
Vivek Khera <vivek@khera.org> writes:

> On Dec 13, 2005, at 2:49 AM, Franz.Rasper@izb.de wrote:
>
> > What is the performance difference between U320 15kRPM and U320  10kRPM ?
> > Does your RAID crontoller has some memory (e.g. 128 MB or 256 MB )
> > and something like memory backup write cache (like HP DL 380 server) ?
> > Do you use Intel or Opteron cpus ?
>
> The 15k drives have higher sustained throughput so theoretically they  would be
> faster for sequential scans of data.  I have no hard numbers  about this,
> though.  See my thread on choosing between them from last  thursday.

Actually the 15k drives have only moderately higher throughput. The top of the
line 15k Maxtor has a maximum throughput of 98MB/s while my 3 year old 7200
rpm drive can get over 50MB/s. Newer 7200rpm drives would be better but they
don't seem to include throughput in their specs.

While that's not bad, the difference in seek time and rotational latency is
the main advantage of a faster drive. The seek time of a 7200rpm is about
8-9ms and the rotational latency about 4ms. The seek time of the to of the
line 15kRPM drive is about 3ms and the rotational latency 2ms.

In short while the throughput is less than doubled, the speed for random
access reads is almost tripled.

--
greg

pgsql-general by date:

Previous
From: "Andrus"
Date:
Subject: Re: Toolkit for creating editable grid
Next
From: Karsten Hilbert
Date:
Subject: Re: timestamp <-> ctime conversion question...