X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 4C182D1B50F for ; Wed, 17 Sep 2003 19:09:08 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 72696-10 for ; Wed, 17 Sep 2003 16:08:36 -0300 (ADT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 07FDAD1B4EB for ; Wed, 17 Sep 2003 16:08:35 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h8HJ8Xpr004694; Wed, 17 Sep 2003 15:08:33 -0400 (EDT) To: adler@pobox.com Cc: pgsql-performance@postgresql.org Subject: Re: inferior SCSI performance In-reply-to: References: <3F688CC5.12621.4EBFDCC@localhost> Comments: In-reply-to Michael Adler message dated "Wed, 17 Sep 2003 14:55:40 -0400" Date: Wed, 17 Sep 2003 15:08:33 -0400 Message-ID: <4693.1063825713@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/244 X-Sequence-Number: 3610 Michael Adler 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