Search Postgresql Archives

Re: Performance large tables.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Vivek Khera <vivek@xxxxxxxxx> writes:

> On Dec 13, 2005, at 2:49 AM, Franz.Rasper@xxxxxx 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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux