A database migration can be syntactically correct and still be a poor release candidate. A regular index build can block writes, an ALTER TABLE may wait behind a conflicting lock or hold a strong lock longer than expected, and a large data modification can turn a routine deployment into an incident.
This is a companion discussion topic for the original entry at https://percona.community/blog/2026/09/08/postgresql-migration-preflight-ci/