Sagi Bashari wrote:
I can only speak from my experience. I never lost any data because of MySQL. MySQL supports transactions for few years now so this is not an issue for me.
I was mainly referring to data integrity in the face of power failure/server segmentation fault in the middle of a transaction. These are the type of problems that are extremely uncommon, but extremely dangerous for that very same reason.
Pg's disk data structure is built like a journaled file system, in order to give an assurance against precisely these type of problems. As far as I understood, MySQL's speed comes precisely from the lack of this structure. To me, these are more important than logical transactions when everything is ok. That is also what I meant when I said I'm not sure how you can retrofit such features into an existing database.
Shachar
-- Shachar Shemesh Lingnu Open Source Consulting ltd. http://www.lingnu.com/
================================================================= To unsubscribe, send mail to [EMAIL PROTECTED] with the word "unsubscribe" in the message body, e.g., run the command echo unsubscribe | mail [EMAIL PROTECTED]
