Re: inferior SCSI performance

From: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
To: Andrew Sullivan <andrew(at)libertyrms(dot)info>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: inferior SCSI performance
Date: 2003-10-01 13:14:32
Message-ID: Pine.LNX.4.33.0310010713250.20754-100000@css120.ihs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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)

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message scott.marlowe 2003-10-01 13:23:08 Re: TPC-R benchmarks
Previous Message Mindaugas Riauba 2003-10-01 13:05:41 Re: What is the fastest null WHERE