Re: SCSI vs. IDE performance test
Ron Johnson <ron.l.johnson@cox.net>
From: Ron Johnson <ron.l.johnson@cox.net>
To: PgSQL General ML <pgsql-general@postgresql.org>
Date: 2003-10-24T08:51:29Z
Lists: pgsql-general
On Wed, 2003-10-22 at 11:01, Stephen wrote: > The SCSI improvement over IDE seems overrated in the test. I would have > expected at most a 30% improvement. Other reviews seem to point out that IDE > performs just as well or better. > > See Tom's hardware: > http://www20.tomshardware.com/storage/20020305/index.html When TCQ becomes a reality in IDE drives, they'll have a fighting chance, but the slower seek times and rotational speeds will still do them in. Also, does an 8MB cache *really* make that much of a difference? After all, it can only cache 0.0067% of a 120GB drive, and 0.00267% of the new 300GB disks. Speaking of which, that 300GB HDD sounds like a dream for near- line storage, and even for nightly backups, if it is ever put in SBB-type packaging. http://www20.tomshardware.com/storage/20031008/index.html Imagine a scheme where you rapidly pg_dump to the 300GB drive, then, at leisure, tar the dump file to tape. Stripe a few together, and keep a month of backups on-line for quick recovery, along with the tape archives, in case the stripeset gets wasted, too. > "Ron Johnson" <ron.l.johnson@cox.net> wrote in message > news:1066837102.12532.176.camel@haggis... > > > http://hardware.devchannel.org/hardwarechannel/03/10/20/1953249.shtml?tid=20 > &tid=38&tid=49 -- ----------------------------------------------------------------- Ron Johnson, Jr. ron.l.johnson@cox.net Jefferson, LA USA "Adventure is a sign of incompetence" Stephanson, great polar explorer