hard20 pts · first answer countsdatabasesindexesmigrations

Adding an index without blocking writes

You need a new index on a 200 GB orders table that takes writes all day. Which PostgreSQL command avoids blocking inserts and updates while it builds?

A.CREATE INDEX inside a transactionB.REINDEX TABLE ordersC.CREATE INDEX CONCURRENTLYD.ALTER TABLE orders ADD INDEX

Discussion 0

Join free to post in the discussion.

Adding an index without blocking writes

Discussion 0

Related questions