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