Fix for PostgreSQL behavior in MDL-35506 introduced a performance regression for PostgreSQL transactions.

Possible workaround could be to implement new support for new option $rollbackonerror in $DB->start_delegated_transaction(), this would rollback everything automatically. The problem is that developers need to be a lot more careful when using try-catch. We may have to implement some new advanced diagnostics to detect new types of coding errors...