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
ALTER TABLE always rewrites the table
B
It disables replication
C
It deletes indexes
D
It needs an ACCESS EXCLUSIVE lock; waiting behind a long query, it blocks every new query queued after it