Re: Improving REINDEX for system indexes (long)

Tom Lane wrote:
> > What about creating a separate filenode anyway and renaming the files
> > afterwards?  It would not be an atomic operation anyway, but it would be
> > better than the current setup IMHO.
> 
> I think it would be difficult to persuade the buffer manager and storage
> manager to work with this; from their point of view you'd be moving a
> relation underneath them.  I doubt it's really worth the trouble; how
> often do you need to reindex a shared catalog?

The point I missed originally is that he is talking about shared
catalogs, not system catalogs, which work fine in CVS.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073