Your Agent's ADD FOREIGN KEY Stalls Writes on Two Tables. NOT VALID, Then VALIDATE

ADD FOREIGN KEY takes a write-blocking lock on both tables while it scans. Reproduce it in Docker, then split it into NOT VALID and VALIDATE.

Read Original

Related