Re: inferior SCSI performance - Mailing list pgsql-performance

From scott.marlowe
Subject Re: inferior SCSI performance
Date
Msg-id Pine.LNX.4.33.0310010713250.20754-100000@css120.ihs.com
Whole thread Raw
In response to Re: inferior SCSI performance  (Andrew Sullivan <andrew@libertyrms.info>)
Responses Re: inferior SCSI performance
List pgsql-performance
On Wed, 1 Oct 2003, Andrew Sullivan wrote:

> On Wed, Sep 17, 2003 at 04:46:00PM -0400, Michael Adler wrote:
> > So the quesiton is whether it is ever sensible to use write-caching and
> > expect comparable persistence.
>
> Yes.  If and only if you have a battery-backed cache.  I know of no
> IDE drives that have that, but there's nothing about the spec which
> makes it impossible.

FYI, on a Dual PIV2800 with 2 gig ram and a single UDMA 80 gig hard drive,
I from 420 tps to 22 tps when I disable write caching.  WOW.  A factor of
about 20 times slower.  (pgbench -c 4 -t 100)


pgsql-performance by date:

Previous
From: "Mindaugas Riauba"
Date:
Subject: Re: What is the fastest null WHERE
Next
From: Andrew Sullivan
Date:
Subject: Re: inferior SCSI performance