Josh Tolley wrote: > > On 4/7/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > As to losing data, I suspect you'd lose a lot more > > from PostgreSQL than MySQL on a failing hard drive. > > Any particular reason for that suspicion? I ask out of genuine > interest, and I promise I don't want to start a flame war. > > -Josh
It has to do with how much information other than that essential to the data itself, and how sensitive a system would be to corruption of that data. Any provision so that readers do not interfere with writers requires a vastly more complicated structure which must be much more sensitive to errors than something that does not exist. However, if there is redundancy, and you can take advantage of that redundancy, the odds shift enormously. Taking advantage is .... non-trivial maybe the best term.