I don't know about Postgres but for MySQL on servers at Cash App we never just call the database to apply schema changes. Instead we use gh-ost so the DB isn't locked and unavailable during the schema change
01/13/2022, 3:35 PM
I didn’t know something like this existed for relational databases! This basically allows zero downtime migrations!