Re:The Ten Rules of Schema Growth
by cdchn on Tuesday October 31, 2023 @09:06PM
(#38093422)
>Instead of changing all the rows in a single big transaction, the change was broken into thousands of little changes that were rolled out over a series of days.
Having been in a situation where a large schema update required migrating data in a transaction, which then broke for some data, but the data was so big that rolling back the transaction caused the database to become totally hosed, I can see this technique being very attractive.
Having been in a situation where a large schema update required migrating data in a transaction, which then broke for some data, but the data was so big that rolling back the transaction caused the database to become totally hosed, I can see this technique being very attractive.