Adding an index to a table with big amount of data causes a lag for both
INSERT operations on that table, doesn't it?
While PostgreSQL does not support live (without lags) adding of indexes, how to solve the problem of adding an index to a table without lagging
INSERT (there is no
UPDATEs on that table)?
My idea is to copy the table by small chunks to another table with the same structure, then in a transaction delete the original table and rename the new table to the original table name. How to ensure that the entire data is copied, while
INSERT operations to the old table may happen?