Update size after commit

What does this MR do?

Should improve the: #24286 (closed).

We move update of statistics into a separate much smaller transaction.

Does this MR meet the acceptance criteria?

Conformity

• Changelog entry
• Documentation (if required)
• Code review guidelines
• Merge request performance guidelines
• Style guides
• Database guides
• Separation of EE specific content