Re: SCSI vs. IDE performance test - Mailing list pgsql-general

From list-pgsql-general@news.cistron.nl ("Miquel van Smoorenburg" )
Subject Re: SCSI vs. IDE performance test
Date
Msg-id bnter5$730$1@news.cistron.nl
Whole thread Raw
In response to Re: SCSI vs. IDE performance test  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
In article <87n0blgs9g.fsf@stark.dyndns.tv>,
Greg Stark  <gsstark@mit.edu> wrote:
>Currently the linux-kernel folks are talking about how to integrate an IDE
>SYNC operation into the world. It looks like filesystems with journals will
>issue an IDE SYNC to checkpoint the journal, but it doesn't really look like
>they're planning to hook it into fsync unless people speak up and explain what
>databases need in that regard. However SYNC flushes the entire cache and means
>that all other writes are blocked until the SYNC completes.
>
>http://www.ussg.iu.edu/hypermail/linux/kernel/0304.1/0450.html

Also, if you're interested in this kind of stuff and what's going on
in the Linux kernel development circles, Google for "ide write barrier".

For example http://lkml.org/lkml/2003/10/13/87

Mike.

pgsql-general by date:

Previous
From: Mark Kirkwood
Date:
Subject: Re: slow query performance
Next
From: Alex
Date:
Subject: ALTER Table