> > REINDEX is a marginally prettier answer; at least you don't have to
> > remember the index parameters. Shrinking indexes on-the-fly is still
> > on the TODO list.
>
> But at least in 7.1 REINDEX has to be run under stand-alone Postgres, or
> so say the docs:
>
> REINDEX is used to recover corrupted system indexes. In order to run
> REINDEX command, postmaster must be shut down and stand-alone Postgres
> should be started instead with options -O and -P (an option to ignore
> system indexes).
>
> Whereas the DROP INDEX/CREATE INDEX method works on-the-fly. You may end
> up running a seqscan somewhere, but that's not so big a problem, IMHO.
The single-user warning is only for system index reindexing.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026