Re: do postgresql this job for me ? (firebird user)

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;