Re: Low Budget Performance, Part 2 - Mailing list pgsql-performance

From scott.marlowe
Subject Re: Low Budget Performance, Part 2
Date
Msg-id Pine.LNX.4.33.0212041323520.15194-100000@css120.ihs.com
Whole thread Raw
In response to Re: Low Budget Performance, Part 2  (eric soroos <eric-psql@soroos.net>)
List pgsql-performance
On Thu, 28 Nov 2002, eric soroos wrote:

> The rotational speed difference is 40% (10k/7.2k), and the TPS
> difference is about 60% (50/30 or 40/25)

I would suggest that areal density / xfer rate off the platters is the
REAL issue, not rotational speed.  Rotational speed really only has a
small effect on the wait time for the heads to get in position, whereas
xfer rate off the platters is much more important.

My older 7200RPM 2Gig and 4Gig UW SCSI drives are no match for my more
modern 40 Gig 5400 RPM IDE drive, which has much higher areal density and
xfer rate off the platters.  While it may not spin as fast, the bits /
cm2 are MUCH higher on that drive, and I can get around 15 megs a second
off of it with bonnie++.  The older 4 gig UW drives can hardly break 5
Megs a second xfer rate.

Of course, on the drives you're testing, it is quite likely that the xfer
rate on the 10k rpm drives are noticeably higher than the xfer rate on
the 7200 rpm IDE drives, so that is likely the reason for the better
performance.


pgsql-performance by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: Is there any limitations
Next
From: Vernon Wu
Date:
Subject: Is a better way to have the same result of this query?