On May 24, 2009, at 8:58 AM, Craig Ringer wrote:
> There isn't currently any REINDEX CONCURRENTLY
> option, but people seem to have a few workarounds that do the job if
> you
> really do need to rebuild an index on a live, active table.
It's pretty straight-forward to do:
CREATE INDEX CONCURRENTLY idx_new ON table ... ;
DROP INDEX idx;
ALTER INDEX idx_new RENAME TO idx;