medium10 pts · first answer countsindexingpostgresql

Adding an index on a live table

You need a new index on a busy 300 GB PostgreSQL table without blocking writes. What should you run?

A.CREATE INDEX inside a transaction at nightB.VACUUM FULL, then CREATE INDEXC.CREATE INDEX CONCURRENTLY, then check that the index is valid afterwardsD.LOCK TABLE ... IN SHARE MODE, then CREATE INDEX

← UNIQUE column with NULLs Sort Method: external merge →