Alvaro Herrera <[EMAIL PROTECTED]> writes: > On Sat, Sep 27, 2003 at 06:37:22PM -0400, Tom Lane wrote: >> I don't see any way to avoid that, though, since we cannot change the >> relfilenode value for a shared index.
> 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? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly