3 ms·
> This might cause the whole table to be locked and copied in SQL. The answer is always the same to these kinds of complaints: just use Postgres please.
by nlitened 6y ago
> This might cause the whole table to be locked and copied in SQL.
The answer is always the same to these kinds of complaints: just use Postgres please.
- pseudoramble 6y agoIf 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?
- funcDropShadow 6y agoIf the added column is nullable or if you provide a constant default value, the table is not copied, neither online nor offline.