It seems to me that if the machine crashes in the middle of a
transaction that there will be or is a very high chance of database
corruption. I don't know if and how postgresql would detect and
handle that after the system reboots. We are running mysql here and
haven't had any data integrity problems.