In your illustration of logical logging, you log the before and after, does this apply to huge writes? e.g. update something where id > 1000 This can modify say 1000 rows. If we still log before and after, our logical logging will have 1000 rows. Then why do you say logical log size is smaller than physical log size? Cuz I feel like in both cases, all the data is fully fleshed out in the log.
In your illustration of logical logging, you log the before and after, does this apply to huge writes? e.g. update something where id > 1000
This can modify say 1000 rows. If we still log before and after, our logical logging will have 1000 rows.
Then why do you say logical log size is smaller than physical log size? Cuz I feel like in both cases, all the data is fully fleshed out in the log.