Re: Performance large tables.

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: Performance large tables.
Дата
Msg-id 87slswervi.fsf@stark.xeocode.com
обсуждение исходный текст
Ответ на Re: Performance large tables.  (Vivek Khera <vivek@khera.org>)
Список 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 по дате отправления:

Предыдущее
От: "Andrus"
Дата:
Сообщение: Re: Toolkit for creating editable grid
Следующее
От: Karsten Hilbert
Дата:
Сообщение: Re: timestamp <-> ctime conversion question...