Practice
Learn
← Quit
0 / 0 correct
Databases
Hard
1 of 344
Why can ALTER TABLE on a big Postgres table cause an outage even if the change is quick?
A
ALTER TABLE always rewrites the table
B
It needs an ACCESS EXCLUSIVE lock; waiting behind a long query, it blocks every new query queued after it
C
It deletes indexes
D
It disables replication