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