May 2018
Intermediate to advanced
576 pages
30h 25m
English
The CREATE INDEX CONCURRENTLY statement allows INSERT, UPDATE, and DELETE commands while the index is being created. It cannot be executed inside another transaction, and only one index per table can be created concurrently at any time.
Swapping the indexes is easy and doesn't use any trickery.