08.05.2014 22:08, Dimitry Sibiryakov wrote: > In this case transaction won't be marked as committed and record will be > garbage > collected sooner or later.
Ah, so you meant the case where both TIP and the data page were written to disk, but the index page was not? Here I agree that FW=OFF makes the difference. But it has nothing to do with the careful writes, even if there will be a precedence dependency, it would be effectively disabled by FW=OFF. But I believe this is more possible for an OS crash rather than for Firebird crash. I doubt that OS silently discards unflushed changes from its filesystem cache just because the process crashed. Dmitry ------------------------------------------------------------------------------ Is your legacy SCM system holding you back? Join Perforce May 7 to find out: • 3 signs your SCM is hindering your productivity • Requirements for releasing software faster • Expert tips and advice for migrating your SCM now http://p.sf.net/sfu/perforce Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
