In the following situation:
You do a large transaction where lots of rows are update
All of your tables/indexes cached in memory
When are the updated rows written out to disk? When they are updated inside
the transaction, or when the transaction is completed?