It seems to me file system journaling should fix the whole problem by giving you a record of what was actually commited to disk and what was not. I must not understand journaling correctly. Can anyone explain to me how journaling works.
----- Original Message ----- From: "Bruce Momjian" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "Stephen" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, October 27, 2003 12:14 PM Subject: Re: [GENERAL] SCSI vs. IDE performance test > Mike Benoit wrote: > > I just ran some benchmarks against a 10K SCSI drive and 7200 RPM IDE > > drive here: > > > > http://fsbench.netnation.com/ > > > > The results vary quite a bit, and it seems the file system you use > > can make a huge difference. > > > > SCSI is obviously faster, but a 20% performance gain for 5x the cost is > > only worth it for a very small percentage of people, I would think. > > Did you turn off the IDE write cache? If not, the SCSI drive is > reliable in case of OS failure, while the IDE is not. > > -- > Bruce Momjian | http://candle.pha.pa.us > [EMAIL PROTECTED] | (610) 359-1001 > + If your life is a hard drive, | 13 Roberts Road > + Christ can be your backup. | Newtown Square, Pennsylvania 19073 > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match