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;
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
