If the system crashes while a transaction still in progress, what will happen to it in recovery? Will it be rollbacked? For example, if I insert a row and the insertion has been xlogged, then the system crashes before this transaction commits, will this insertion be cancelled in recovery?