> By the way, may I ask more question regarding Oracle? You mentioned
> the magic of no-fsync in Oracle is actually a bug. Ok, I understand. I
> also heard that Oracle does some kind of redo-log bufferings. Does
> this mean certain committed data might be lost if the system crashed
> before the buffered data is written into the disk?
That is my guess. Informix does that. No run runs with non-buffered
logging. They run with buffered logging, which may loose transactions
for a few seconds or minutes before a crash.
I think we need that, and it should be the default, but few people agree
with me. I have some schemes to do this.
-- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026