Re: Contrib reindex script:

Neil Conway wrote:
> On Thu, 13 Jun 2002 13:13:29 -0400 (EDT)
> "Bruce Momjian" <pgman@candle.pha.pa.us> wrote:
> > First, I think we need a section in the admin/maintenance manual talking
> > about reindex.  (We already have vacuum there, and I think reindex is
> > something that periodically also should be done.)
>
> One simple improvement would be to change the documentation's view of
> REINDEX -- at the moment, it says that it's only useful for rebuilding
> "corrupted indexes". If it's a legitimate maintainence activity for
> certain query loads, it should get a more positive spin.

Done.

> Also, could we enhance REINDEX to not require an exclusive table lock?
> Without looking at the code, I would think that we could at least allow
> for SELECTs (using seqscans or other indexes) while a REINDEX is running.

Yes, that would be nice.

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