Re: Recomended FS - Mailing list pgsql-general

From Jeff
Subject Re: Recomended FS
Date
Msg-id 20031020080934.2401ee02.threshar@torgo.978.org
Whole thread Raw
In response to Re: Recomended FS  (Nick Burrett <nick@dsvr.net>)
Responses Re: Recomended FS  ("Matthew D. Fuller" <fullermd@over-yonder.net>)
List pgsql-general
On Mon, 20 Oct 2003 11:07:20 +0100
Nick Burrett <nick@dsvr.net> wrote:


>  From experience I have noticed that IDE drives that initially perform
>
> at 30Mbyte/sec dropped to around 10Mbyte/sec after a year or so.
>

Yes. This is very true - a good test I like to show of IDE falling apart
is to start up one client and show it go very fast.  Then start up 20
and see what happens :)

Also - you can easily have many, many more scsi devices (and external
scsi devices) than IDE.  More platters / disks == faster IO.


> >
> > IDE Hard Disk 40Gb 7200RPM   = 133Mbs = 50UKP
> > SCSI Hard Disk 36Gb 10000RPM = 160Mbs = 110UKP
>

If you don't mind refurb disks that still have a warranty, check out
ebay.  Friday I won a lot of 10 18GB disks for $96 + $27
insured shipping.   But yeah, new scsi is quite expensive, but it can be
worth it...  IMHO scsi is to be used in a raid, not alone.  No one disk
can saturate the bw offered. (both ide and scsi).


--
Jeff Trout <jeff@jefftrout.com>
http://www.jefftrout.com/
http://www.stuarthamm.net/

pgsql-general by date:

Previous
From: Jeff
Date:
Subject: Re: VACUUM degrades performance significantly. Database
Next
From: Nick Burrett
Date:
Subject: Re: Recomended FS