On Wed, 4 Feb 2004, Iain wrote: > If I understand checkpoints correctly, data that is already written to the > WAL (and flushed to disk) is being written to the DB (flushing to disk). > Meanwhile, other writer transactions are continuing to busily write to the > WAL. In which case a disk bandwidth problem (other than kernal config > issues) may be helped by placing the WAL files on a disk (and maybe even > controller) seperate from the DB.
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. ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])