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

From Peter Galbavy
Subject Re: hanging for 30sec when checkpointing
Date
Msg-id 009101c3ed69$1e637790$24e0a8c0@sonylaptop
Whole thread Raw
In response to Re: hanging for 30sec when checkpointing  ("scott.marlowe" <scott.marlowe@ihs.com>)
Responses Re: hanging for 30sec when checkpointing  (Andrew Sullivan <ajs@crankycanuck.ca>)
Re: hanging for 30sec when checkpointing  ("scott.marlowe" <scott.marlowe@ihs.com>)
List pgsql-admin
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...

Peter

pgsql-admin by date:

Previous
From: "Peter Galbavy"
Date:
Subject: Re: hung postmaster when client machine dies?
Next
From: Andrew Sullivan
Date:
Subject: Re: hanging for 30sec when checkpointing