Re: RES: [PERFORM] Initial database loading and IDE x SCSI

2006-06-03 Thread Mark Kirkwood
Bruce Momjian wrote: The definitive guide to servers vs. desktop drives is: http://www.seagate.com/content/docs/pdf/whitepaper/D2c_More_than_Interface_ATA_vs_SCSI_042003.pdf Yeah - very nice paper, well worth a read (in spite of the fact that it is also Seagate propaganda, supporting th

Re: RES: [PERFORM] Initial database loading and IDE x SCSI

2006-06-03 Thread Bruce Momjian
Mark Kirkwood wrote: > Mark Lewis wrote: > > > > > The naive approach works on IDE drives because they don't (usually) > > honor the request to write the data immediately, so it can fill its > > write cache up with several megabytes of data and write it out to the > > disk at its leisure. > > >

Re: RES: [PERFORM] Initial database loading and IDE x SCSI

2006-06-02 Thread Mark Kirkwood
Mark Lewis wrote: The naive approach works on IDE drives because they don't (usually) honor the request to write the data immediately, so it can fill its write cache up with several megabytes of data and write it out to the disk at its leisure. FWIW - If you are using MacOS X or Windows, the

Re: RES: [PERFORM] Initial database loading and IDE x SCSI

2006-06-02 Thread Mark Lewis
On Fri, 2006-06-02 at 16:54 -0300, [EMAIL PROTECTED] wrote: > > <[EMAIL PROTECTED]> writes: > > > I would like to know if my supposition is right. > > > > > Considering an environment with only one hard disk attached to > > a server, an > > > initial loading of the database probably is much faster