Re: Performance tuning in PostgreSQL - Mailing list pgsql-general

From Dennis Gearon
Subject Re: Performance tuning in PostgreSQL
Date
Msg-id 3E833076.7020600@cvc.net
Whole thread Raw
In response to Re: Performance tuning in PostgreSQL  ("Daniel R. Anderson" <dan@mathjunkies.com>)
Responses Re: Performance tuning in PostgreSQL  (Arjen van der Meijden <acm@tweakers.net>)
List 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 by date:

Previous
From: Dennis Gearon
Date:
Subject: Re: Reverse engineering PG database
Next
From: Ken Guest
Date:
Subject: Re: Reverse engineering PG database