News for hackers. Stuff that matters.

A comment on Have the Tables Turned on NoSQL?. Parent comment

Re:Have the Tables Turned on NoSQL? by nlitened on Saturday January 16, 2021 @04:20AM (#25801139)
> 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.

[ Parent | on HN ]
Re:Have the Tables Turned on NoSQL? by pseudoramble on Saturday January 16, 2021 @09:55AM (#25802557)
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?
[ Parent | on HN ]
Re:Have the Tables Turned on NoSQL? by funcDropShadow on Saturday January 16, 2021 @10:32AM (#25802812)
If the added column is nullable or if you provide a constant default value, the table is not copied, neither online nor offline.
[ Parent | on HN ]