Re: index files still growing

> > 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