Hacker News new | ask | show | jobs
by brianwawok 1969 days ago
Excellent there you go.

Is there a way to just do the index build part, short of dropping an index and adding it back?

2 comments

This is described about a quarter the way into TFA.

> REINDEX INDEX CONCURRENTLY index_name;

(A vanilla REINDEX will lock the table, preventing writes, while it runs. The CONCURRENT creates a new index, replicates any updates to the original while it does so, and then does an atomic switcheroo at the end.)

I believe pg_repack can do that.