If you don’t mind me asking, how does Postgres fix this? Do they have a more sophisticated locking mechanism, or maybe a copy offline until it’s ready kind of a system?
If the added column is nullable or if you provide a constant default value, the table is not copied, neither online nor offline.