On Oct 27, 2011, at 1:09 AM, Konstantin Cherkasov wrote: I meant "one day" = "once" in the sense that buffer usually does not assume durability. In other words, if you choose to buffer the data then you are ready that there is a probability the data can be lost.
Face it: the data’s going to get buffered somewhere. If you don’t buffer it, then either the database server will, or the OS kernel will, or the disk controller will. It’s definitely fastest to let the controller do the buffering, but since it knows nothing of your file format or even the disk’s volume format, the results of data loss are much worse (i.e. file corruption.) Doing the buffering at a higher level provides better reliability at the expense of performance. —Jens
