blue/green: Update items in the transaction all at once

[ParkMyCar]

This PR slightly refactors the RenameSchema op to update the durable transaction with the new items all at once instead of calling tx.update_item(...) for each item. update_item(...) iterates through the entire catalog every time it's called so it can be quite slow.

Creating two schemas with 100 views each, and then 500 views depending on the 100 views in a schema we exhibit the following performance.

main

materialize=> ALTER SCHEMA blue SWAP WITH green;
ALTER SCHEMA
Time: 37301.170 ms (00:37.301)

This PR

materialize=> ALTER SCHEMA blue SWAP WITH green;
ALTER SCHEMA
Time: 470.736 ms

Motivation

Greatly improves the speed of ALTER SCHEMA ... SWAP WITH ...

Checklist

• This PR has adequate test coverage / QA involvement has been duly considered.
• This PR has an associated up-to-date design doc, is a design doc (template), or is sufficiently small to not require a design.
• If this PR evolves an existing $T ⇔ Proto$T mapping (possibly in a backwards-incompatible way), then it is tagged with a T-proto label.
• If this PR will require changes to cloud orchestration or tests, there is a companion cloud PR to account for those changes that is tagged with the release-blocker label (example).
• This PR includes the following user-facing behavior changes:
  • Performance improvement for ALTER SCHEMA ... SWAP WITH ...

[jkosh44]

Nice!

[benesch]

Nice! Can we add a test for this? Maybe in test/limits? No need to block this PR on it. And perhaps @MaterializeInc/testing have some cycles to assist.

[ParkMyCar]

Nice! Can we add a test for this? Maybe in test/limits? No need to block this PR on it. And perhaps @MaterializeInc/testing have some cycles to assist.

Will do! I'll follow up with the testing team about this

[nrainer-materialize]

Will do! I'll follow up with the testing team about this

The test will be added with #26377.