Re: How to improve db performance with $7K?

Поиск
Список
Период
Сортировка
От Jim C. Nasby
Тема Re: How to improve db performance with $7K?
Дата
Msg-id 20050419230836.GQ58835@decibel.org
обсуждение исходный текст
Ответ на Re: How to improve db performance with $7K?  (Matthew Nuzum <mattnuzum@gmail.com>)
Список pgsql-performance
On Thu, Apr 14, 2005 at 10:51:46AM -0500, Matthew Nuzum wrote:
> So if you all were going to choose between two hard drives where:
> drive A has capacity C and spins at 15K rpms, and
> drive B has capacity 2 x C and spins at 10K rpms and
> all other features are the same, the price is the same and C is enough
> disk space which would you choose?
>
> I've noticed that on IDE drives, as the capacity increases the data
> density increases and there is a pereceived (I've not measured it)
> performance increase.
>
> Would the increased data density of the higher capacity drive be of
> greater benefit than the faster spindle speed of drive A?

The increased data density will help transfer speed off the platter, but
that's it. It won't help rotational latency.
--
Jim C. Nasby, Database Consultant               decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"

В списке pgsql-performance по дате отправления:

Предыдущее
От: Mark Wong
Дата:
Сообщение: Re: [HACKERS] PLM pulling from CVS nightly for testing in STP
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: How to improve db performance with $7K?