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