Re: inferior SCSI performance - Mailing list pgsql-performance

From Tom Lane
Subject Re: inferior SCSI performance
Date
Msg-id 4693.1063825713@sss.pgh.pa.us
Whole thread Raw
In response to inferior SCSI performance  (Michael Adler <adler@pobox.com>)
Responses Re: inferior SCSI performance
List pgsql-performance
Michael Adler <adler@pobox.com> writes:
> I have been experimenting with a new Seagate Cheetah 10k-RPM SCSI to
> compare with a cheaper Seagate Barracuda 7200-RPM IDE (each in a
> single-drive configuration). The Cheetah definately dominates the generic
> IO tests such as bonnie++, but fares poorly with pgbench (and other
> postgresql operations).

It's fairly common for ATA drives to be configured to lie about write
completion (ie, claim write-complete as soon as data is accepted into
their onboard RAM buffer), whereas SCSI drives usually report write
complete only when the data is actually down to disk.  The performance
differential may thus be coming at the expense of reliability.  If you
run Postgres with fsync off, does the differential go away?

            regards, tom lane

pgsql-performance by date:

Previous
From: Michael Adler
Date:
Subject: inferior SCSI performance
Next
From: "Matt Clark"
Date:
Subject: Is there a reason _not_ to vacuum continuously?