Re: Performance tuning in PostgreSQL

Поиск
Список
Период
Сортировка
От Dennis Gearon
Тема Re: Performance tuning in PostgreSQL
Дата
Msg-id 3E833076.7020600@cvc.net
обсуждение исходный текст
Ответ на Re: Performance tuning in PostgreSQL  ("Daniel R. Anderson" <dan@mathjunkies.com>)
Ответы Re: Performance tuning in PostgreSQL  (Arjen van der Meijden <acm@tweakers.net>)
Список pgsql-general
I read a recent article on Tom's hardware that said, even given the same speed
of data from the read heads and the same buffer size, a SCSI drive will work
better for a server, and the IDE drive will work better for the desktop. The
caching algorithms are optimised with the assumption that a SCSI drive will BE
on a server and an IDE drive will BE on a desktop.

Daniel R. Anderson wrote:
> On Wed, 2003-03-26 at 12:56, Dennis Gearon wrote:
>
>>In General, the rotational speed is higher on SCSCI disks, and this increases
>>the tranfer rate from the disc, which is the limitation for anything not in the
>>disk's cache. Given the same areal dinsity, a 15,000 SCSI drive will be 50%
>>faster in tranfer rate than a 10,000 IDE drive.
>
>
> For anybody interested I got the story off of slashdot:
>
> http://slashdot.org/article.pl?sid=03/02/21/0553249&mode=thread&tid=137
>
> The claim is that these ATA drives have "SCSI-like specs at 30% less of
> the price".  SCSI-LIKE != SCSI though.  :-(
>


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

Предыдущее
От: Dennis Gearon
Дата:
Сообщение: Re: Reverse engineering PG database
Следующее
От: Ken Guest
Дата:
Сообщение: Re: Reverse engineering PG database