Re: hanging for 30sec when checkpointing - Mailing list pgsql-admin

From scott.marlowe
Subject Re: hanging for 30sec when checkpointing
Date
Msg-id Pine.LNX.4.33.0402090956580.23974-100000@css120.ihs.com
Whole thread Raw
In response to Re: hanging for 30sec when checkpointing  ("Peter Galbavy" <peter.galbavy@knowtion.net>)
Responses Re: hanging for 30sec when checkpointing  (matt@ymogen.net)
List pgsql-admin
On Sat, 7 Feb 2004, Peter Galbavy wrote:

> scott.marlowe wrote:
> > Also, running on SCSI drives will be much faster than running on IDE
> > drives if the IDE drives have their caches disabled like they should,
> > since they lie otherwise.  Since SCSI disks don't usually lie, and are
> > designed to handle multiple requests in parallel, they are much
> > faster as parallel load increases.  If you're writing a lot, you
> > should either have a great number of IDE drives with the write cache
> > turned off, like some of the newer storage devices made of ~100 IDE
> > drives, or you should have SCSI.  SCSI's advantage won't be as great
> > as the number of drives approaches infinity.  But for 1 to 10 drives
> > my guess is that SCSI is gonna be a clear winner under parallel load.
>
> Nice to see old fashioned misinformation being spread around the place...

I don't know who you think you are, but I've physically tested the stuff
I'm talking about.  Care to qualify what you mean?

IDE drives (all the ones I've ever tested) LIE about their write caches
and fsync.  don't believe me?  Simple, hook one up, initiate 100 parallel
transactions, pull the power plug, watch your database fail to come back
up due to the corruption caused by the LYING IDE drives.

Do the same with SCSI.  watch the database come right back to life.

If you're gonna accuse me of lying, you damned well better have the balls
AND evidence to back it up.


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: statistics buffer is full
Next
From: matt@ymogen.net
Date:
Subject: Re: hanging for 30sec when checkpointing