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

I didn’t know something like this existed for relational databases! This basically allows zero downtime migrations!